Oracle8i Supplied Packages Reference Release 8.1.5 A68001-01 |
|
DBMS_REPCAT_ADMIN
enables you to create users with the privileges needed by the symmetric replication facility.
Subprogram | Description |
---|---|
GRANT_ADMIN_ANY_SCHEMA procedure |
Grants the necessary privileges to the replication administrator to administer any replicated object group at the current site. |
GRANT_ADMIN_SCHEMA procedure |
Grants the necessary privileges to the replication administrator to administer a schema at the current site. |
REGISTER_USER_REPGROUP procedure |
Assigns proxy snapshot administrator or receiver privileges at the master site for use with remote sites. |
REVOKE_ADMIN_ANY_SCHEMA procedure |
Revokes the privileges and roles from the replication administrator that would be granted by |
REVOKE_ADMIN_SCHEMA procedure |
Revokes the privileges and roles from the replication administrator that would be granted by |
UNREGISTER_USER_REPGROUP procedure |
Revokes the privileges and roles from the proxy snapshot administrator or receiver that would be granted by the |
This procedure grants the necessary privileges to the replication administrator to administer any replicated object group at the current site.
DBMS_REPCAT_ADMIN.GRANT_ADMIN_ANY_SCHEMA ( username IN VARCHAR2);
Parameter | Description |
---|---|
username |
Name of the replication administrator to whom you want to grant the necessary privileges and roles to administer any replicated object groups at the current site. |
Exception | Description |
---|---|
ORA-01917 |
User does not exist. |
This procedure grants the necessary privileges to the replication administrator to administer a schema at the current site. This procedure is most useful if your object group does not span schemas.
DBMS_REPCAT_ADMIN.GRANT_ADMIN_SCHEMA ( username IN VARCHAR2);
Exception | Description |
---|---|
ORA-01917 |
User does not exist. |
This procedure assigns proxy snapshot administrator or receiver privileges at the master site for use with remote sites. This procedure grants only the necessary privileges to the proxy snapshot administrator or receiver, avoiding having to grant the powerful privileges granted by the GRANT_ADMIN_SCHEMA
or GRANT_ADMIN_ANY_SCHEMA
procedures.
See Also:
See "Advanced Techniques" in the Oracle8i Replication manual for more information on trusted versus untrusted security models. |
DBMS_REPCAT_ADMIN.REGISTER_USER_REPGROUP ( username IN VARCHAR2, privilege_type IN VARCHAR2, list_of_gnames IN VARCHAR2 | table_of_gnames IN dbms_utility.name_array);
Exception | Description |
---|---|
nonmaster |
Specified object group does not exist or the invocation database is not a master. |
ORA-01917 |
User does not exist. |
typefailure |
Incorrect privilege type was specified. |
This procedure revokes the privileges and roles from the replication administrator that would be granted by GRANT_ADMIN_ANY_SCHEMA
.
DBMS_REPCAT_ADMIN.REVOKE_ADMIN_ANY_SCHEMA ( username IN VARCHAR2);
Parameter | Description |
---|---|
username |
Name of the replication administrator whose privileges you want to revoke. |
Exception | Description |
---|---|
ORA-01917 |
User does not exist. |
This procedure revokes the privileges and roles from the replication administrator that would be granted by GRANT_ADMIN_SCHEMA
.
DBMS_REPCAT_ADMIN.REVOKE_ADMIN_SCHEMA ( username IN VARCHAR2);
Parameter | Description |
---|---|
username |
Name of the replication administrator whose privileges you want to revoke. |
Exception | Description |
---|---|
ORA-01917 |
User does not exist. |
This procedure revokes the privileges and roles from the proxy snapshot administrator or receiver that would be granted by the REGISTER_USER_REPGROUP
procedure.
DBMS_REPCAT_ADMIN.UNREGISTER_USER_REPGROUP ( username IN VARCHAR2, privilege_type IN VARCHAR2, list_of_gnames IN VARCHAR2 | table_of_gnames IN dbms_utility.name_array);
Exception | Description |
---|---|
nonmaster |
Specified object group does not exist or the invocation database is not a master. |
ORA-01917 |
User does not exist. |
typefailure |
Incorrect privilege type was specified. |