24.4 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 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 in Oracle Autonomous Database Serverless deployments.

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

Examples

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

EXEC SDO_GCDR.ELOC_GRANT_ACCESS('SCOTT');

PL/SQL procedure successfully completed.