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

24.7 SDO_GCDR.ELOC_REVOKE_ACCESS

Format

SDO_GCDR.ELOC_REVOKE_ACCESS(
     user_name IN VARCHAR2);

Description

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

Parameters

user_name

Name of the user whose access to the Oracle Maps cloud service is to be revoked.

Usage Notes

Note:

The SDO_GCDR.ELOC_REVOKE_ACCESS function is only supported on Oracle Autonomous Database.

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

Examples

The following example revokes the privileges for the user SCOTT to use the geocoder functionality on an Autonomous Database instance. 

EXEC SDO_GCDR.ELOC_REVOKE_ACCESS('SCOTT');

PL/SQL procedure successfully completed.

Parent topic: SDO_GCDR Package (Geocoding)