Oracle DBMS_STREAMS_AUTH
Version 12.2.0.1

General Information
Library Note Morgan's Library Page Header
"I spent my entire adult life looking out for the well-being, the training, the equipping of the troops for whom I was responsible. I will not be lectured about what our military needs by a five-deferment draft dodger,"
~ Sen. Tammy Duckworth
Purpose Manage privileges needed for streams administration
AUTHID CURRENT_USER
Dependencies
DBA_USERS DBMS_STANDARD DBMS_XSTREAM_AUTH
DBMS_APPLY_ADM DBMS_STREAMS_ADM PLITBLM
DBMS_ASSERT DBMS_STREAMS_ADM_UTL STREAMS$_PRIVILEGED_USER
DBMS_LOGREP_UTIL 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
Built-in Functions
Built-in Packages
DBMS_CAPTURE_ADM
DBMS_CDC_PUBLISH
DBMS_CDC_SUBSCRIBE
DBMS_PROPAGATION_ADM
DBMS_RECOVERABLE_SCRIPT
DBMS_STREAMS
DBMS_STREAMS_ADM
DBMS_STREAMS_ADM_UTIL_INT
DBMS_STREAMS_ADVISOR_ADM
DBMS_STREAMS_CDC_ADM
DBMS_STREAMS_CONTROL_ADM
DBMS_STREAMS_HANDLER_ADM
DBMS_STREAMS_MC
DBMS_STREAMS_MC_INV
DBMS_STREAMS_MESSAGING
DBMS_STREAMS_PUB_RPC
DBMS_STREAMS_RPC_INTERNAL
DBMS_STREAMS_TABLESPACE_ADM
Streams Demo 1
Streams Demo 2
What's New In 12cR1
What's New In 12cR2

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-2017 Daniel A. Morgan All Rights Reserved