24.6 SDO_GCDR.ELOC_GRANT_ACCESS

Format

SDO_GCDR.ELOC_GRANT_ACCESS(
     user_name IN VARCHAR2);

Description

Grants privileges for a user to call the Oracle Maps Geocoder on an Autonomous AI Database instance.

Parameters

user_name

Name of the user who requires access to the Oracle Maps cloud service.

Usage Notes

Note:

The SDO_GCDR.ELOC_GRANT_ACCESS function is only supported on Oracle Autonomous AI Database.

You must invoke the SDO_GCDR.ELOC_GRANT_ACCESS function as the ADMIN user in your Autonomous AI Database instance.

Examples

The following example grants the user SCOTT access to use the geocoder functionality on an Autonomous AI Database instance.

EXEC SDO_GCDR.ELOC_GRANT_ACCESS('SCOTT');

PL/SQL procedure successfully completed.