1. Spatial Developer's Guide
  2. Reference Information
  3. SDO_GCDR Package (Geocoding)
  4. SDO_GCDR.ELOC_GRANT_ACCESS

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 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 Database.

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.

Parent topic: SDO_GCDR Package (Geocoding)