Oracle Distributed Systems

Name

DBMS_REPCAT_ADMIN.GRANT_ADMIN_REPGROUP

Synopsis

The GRANT_ADMIN_REPGROUP procedure grants the privileges required to administer a replication group for which the user is the schema owner.

PROCEDURE DBMS_REPCAT_ADMIN.GRANT_ADMIN_REPGROUP
   (userid IN VARCHAR2);

userid is the Oracle user ID for whom you are granting privileges.

This procedure replaces GRANT_ADMIN_REPSCHEMA. The specific privileges granted are:

ALTER SESSION	CREATE CLUSTER
CREATE DATABASE LINK	CREATE PROCEDURE
CREATE SEQUENCE	CREATE SESSION
CREATE SNAPSHOT	CREATE SYNONYM
CREATE TABLE	CREATE TRIGGER
CREATE VIEW	EXECUTE ON SYS.DBMS_DEFER
EXECUTE ON SYS.DBMS_DEFER_SYS	EXECUTE ON SYS.DBMS_REPCAT
EXECUTE ON SYS.DBMSOBJGWRAPPER	UNLIMITED TABLESPACE

GRANT_ADMIN_REPGROUP is not useful if your replication group contains objects belonging to multiple schemas. Such a replication group has to be administered by a user who has been granted privileges via GRANT_ADMIN_ANY_REPGROUP.

There are no restrictions on calling GRANT_ADMIN_REPGROUP.

Exceptions

GRANT_ADMIN.REPGROUP may raise exception ORA-01917 if the specified user does not exist.