Oracle Distributed Systems

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.