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

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

Examples

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

EXEC SDO_GCDR.ELOC_REVOKE_ACCESS('SCOTT');

PL/SQL procedure successfully completed.