CODE
Oracle Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
PSOUG Home Code Snippets Oracle Reference Oracle Functions PSOUG Forum Oracle Blogs Bookmark and Share
 
 Search the Reference Library pages:  

Free
Oracle Magazine
Subscriptions
and Oracle White Papers

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      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us [132 users online]    © 2010 psoug.org