Name
DBMS_REPCAT_ADMIN.REVOKE_ADMIN_ANY_REPGROUP
Synopsis
The REVOKE_ADMIN_ANY_REPGROUP procedure revokes the privileges required to administer any replication group at the current site (see GRANT_ADMIN_ANY_REPGROUP for a list of these privileges). Note that REVOKE_ADMIN_ANY_REPGROUP revokes privileges regardless of whether or not they were obtained via GRANT_ADMIN_ANY_REPGROUP. This procedure replaces REVOKE_ADMIN_ANY_SCHEMA, which is now obsolete.
PROCEDURE DBMS_REPCAT_ADMIN.REVOKE_ADMIN_ANY_REPGROUP (userid IN VARCHAR2);
userid is the Oracle user ID for whom you are revoking privileges.
There are no restrictions on calling REVOKE_ADMIN_ANY_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