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.
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access