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.

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.