Name
DBMS_REPCAT_ADMIN.GRANT_ADMIN_ANY_REPGROUP
Synopsis
The GRANT_ADMIN_ANY_REPGROUP procedure grants the privileges required to administer any replication group at the current site.
PROCEDURE DBMS_REPCAT_ADMIN.GRANT_ADMIN_ANY_REPGROUP (userid IN VARCHAR2);
userid is the Oracle user ID for whom you are granting privileges.
There are no restrictions on calling GRANT_ADMIN_ANY_REPGROUP.
This procedure replaces GRANT_ADMIN_ANY_REPSCHEMA. The specific privileges granted are:
ALTER ANY CLUSTER | ALTER ANY INDEX |
ALTER ANY PROCEDURE | ALTER ANY SEQUENCE |
ALTER ANY SNAPSHOT | ALTER ANY TABLE |
ALTER ANY TRIGGER | ALTER SESSION |
CREATE ANY CLUSTER | CREATE ANY INDEX |
CREATE ANY PROCEDURE | CREATE ANY SEQUENCE |
CREATE ANY SNAPSHOT | CREATE ANY SYNONYM |
CREATE ANY TABLE | CREATE ANY TRIGGER |
CREATE ANY VIEW | CREATE DATABASE LINK |
CREATE SESSION | DELETE ANY TABLE |
DROP ANY CLUSTER | DROP ANY INDEX |
DROP ANY PROCEDURE | DROP ANY SEQUENCE |
DROP ANY SNAPSHOT | DROP ANY SYNONYM |
DROP ANY TABLE | DROP ANY TRIGGER |
DROP ANY VIEW | EXECUTE ANY PROCEDURE |
INSERT ANY TABLE | SELECT ANY TABLE |
UNLIMITED TABLESPACE |
Because the privileges granted to userid are relatively powerful, recipients of these grants should be kept to an absolute minimum.
Be sure to set up a replication administrator account at every master site of a multi-master replication environment. In addition, administration will be easiest if you use the same account name in all locations.
Exceptions
GRANT_ADMIN _ANY_REPGROUP may raise exception ORA-01917 if the specified user does not exist.