Search the Reference Library pages:  

Oracle DBMS_STREAMS_AUTH
Version 11.1
 
General Information
Purpose Manage privileges needed for streams administration
Source {ORACLE_HOME}/rdbms/admin/dbmsstr.sql
Dependencies
DBMS_APPLY_ADM DBMS_REPCAT_COMMON_UTL PLITBLM
DBMS_ASSERT DBMS_REPCAT_DECL UTL_FILE
DBMS_LOGREP_UTIL DBMS_STREAMS_ADM_UTL
Security Model Execute is granted to the EXECUTE_CATALOG_ROLE role
 
GRANT_ADMIN_PRIVILEGE
Grants the privileges needed by a user to be an administrator for streams dbms_streams_auth.grant_admin_privilege(
grantee          IN VARCHAR2,
grant_privileges IN BOOLEAN  DEFAULT TRUE,
file_name        IN VARCHAR2 DEFAULT NULL,
directory_name   IN VARCHAR2 DEFAULT NULL);
See CDC Demo 2
 
GRANT_REMOTE_ADMIN_ACCESS
Grants the privileges to perform remote Streams administration through a database link dbms_streams_auth.grant_remote_admin_access(grantee IN VARCHAR2);
See Streams Demo 1
 
REVOKE_ADMIN_PRIVILEGE
Revokes the streams administration privileges. Optionally generates a script whose execution has the same effect dbms_streams_auth.revoke_admin_privilege(
grantee           IN VARCHAR2,
revoke_privileges IN BOOLEAN  DEFAULT TRUE,
file_name         IN VARCHAR2 DEFAULT NULL,
directory_name    IN VARCHAR2 DEFAULT NULL);
See CDC Demo 2
 
REVOKE_REMOTE_ADMIN_ACCESS
Revokes the privileges to perform remote Streams administration through a database link dbms_streams_auth.revoke_remote_admin_access(grantee IN VARCHAR2);
See Streams Demo 1
 
Related Topics
Advanced Queuing
DBMS_CAPTURE_ADM
DBMS_CDC_PUBLISH
DBMS_CDC_SUBSCRIBE
DBMS_PROPAGATION_ADM
DBMS_STREAMS
DBMS_STREAMS_ADM
Streams Demo 1
Streams Demo 2
 
   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us    © 2003 - 2024 psoug.org
-----