Name

DBMS_REPCAT_ADMIN.REVOKE_ADMIN_REPGROUP

Synopsis

REVOKE_ADMIN_REPGROUP revokes from userid all privileges required to administer a replication group with the same name as userid (see GRANT_ADMIN_REPGROUP for a list of these privileges). Note that REVOKE_ADMIN_REPGROUP revokes privileges regardless of whether they were obtained via GRANT_ADMIN_REPGROUP. This procedure replaces REVOKE_ADMIN_REPSCHEMA, which is now obsolete.

PROCEDURE DBMS_REPCAT_ADMIN.REVOKE_ADMIN_REPGROUP
   (userid IN VARCHAR2);

userid is the Oracle user ID for whom you are revoking privileges.

There are no restrictions on calling REVOKE_ADMIN_REPGROUP.

Exceptions

REVOKE_ADMIN_REPGROUP may raise exception ORA-01917 if the specified user does not exist.

Get Oracle Distributed Systems now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.