Oracle DBMS_STREAMS_AUTH
Version 12.1.0.1

General Information
Library Note Morgan's Library Page Footer
The Library is currently in the process of being upgraded from Oracle Database Version 12.1.0.1 to 12.1.0.2. Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs, and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.

Interested in Oracle GoldenGate? Check out the IGGOUG,
Purpose Manage privileges needed for streams administration
AUTHID CURRENT_USER
Dependencies
DBMS_APPLY_ADM DBMS_REPCAT_DECL DBMS_XSTREAM_AUTH
DBMS_ASSERT DBMS_STREAMS_ADM PLITBLM
DBMS_LOGREP_UTIL DBMS_STREAMS_ADM_UTL STREAMS$_PRIVILEGED_USER
DBMS_REPCAT_COMMON_UTL DBMS_UTILITY UTL_FILE
Documented Yes
First Available 12.1.0
Security Model Owned by SYS with EXECUTE granted to the EXECUTE_CATALOG_ROLE role
Source {ORACLE_HOME}/rdbms/admin/dbmsstr.sql
Subprograms
 
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_RECOVERABLE_SCRIPT
DBMS_STREAMS
DBMS_STREAMS_ADM
DBMS_STREAMS_ADVISOR_ADM
DBMS_STREAMS_CDC_ADM
DBMS_STREAMS_HANDLER_ADM
DBMS_STREAMS_MC
DBMS_STREAMS_MC_INV
DBMS_STREAMS_MESSAGING
DBMS_STREAMS_TABLESPACE_ADM
Packages
Streams Demo 1
Streams Demo 2

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2014 Daniel A. Morgan All Rights Reserved