$page_title = $titlebar_text; $header_bar_text = $titlebar_text; ///////////////////////////////////// // get header include('rlib_header.php'); // print << 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
  EOM; ///////////////////////////////////// // get footer include('rlib_footer.php'); ?>