December 2002
Intermediate to advanced
928 pages
85h 29m
English
PROCEDURE DBMS_REPCAT_ADMIN.GRANT_ADMIN_ANY_SCHEMA
(username IN VARCHAR2),
Grants username privileges to administer any replication groups at the current site.
PROCEDURE DBMS_REPCAT_ADMIN.GRANT_ADMIN_SCHEMA
(username IN VARCHAR2),
Grants username privileges to administer replication groups with the same schema at the current site.
PROCEDURE 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});
Assigns privilege_type (RECEIVER for receiver privileges or PROXY_SNAPADMIN for proxy materialized view administrative privileges) to username for a list of the groups in the last parameter. New with Oracle8i.
PROCEDURE DBMS_REPCAT_ADMIN.REVOKE_ADMIN_ANY_SCHEMA
(username IN VARCHAR2);
Revokes all privileges assigned to username by GRANT_ADMIN_ANY_SCHEMA.
PROCEDURE DBMS_REPCAT_ADMIN.REVOKE_ADMIN_SCHEMA
(username IN VARCHAR2);
Revokes all privileges assigned to username by GRANT_ADMIN_SCHEMA.
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});
Removes privilege_type (RECEIVER for receiver privileges or PROXY_SNAPADMIN for proxy materialized view administrative privileges) to username for a list of the groups in the last parameter. New with Oracle8i.