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.