Replication Management API Reference, 119 of 179

REVOKE_ADMIN_SCHEMA procedure

This procedure revokes the privileges and roles from the replication administrator that were granted by GRANT_ADMIN_SCHEMA.

Note:
Identical privileges and roles that were granted independently of GRANT_ADMIN_SCHEMA are also revoked.

DBMS_REPCAT_ADMIN.REVOKE_ADMIN_SCHEMA (
   username IN VARCHAR2);

Parameter	Description
username	Name of the replication administrator whose privileges you want to revoke.

Exception	Description
ORA-01917	User does not exist.