Oracle | DBMS_STREAMS

Oracle DBMS_STREAMS_AUTH Version 23c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

Purpose Manage privileges needed for streams administration

Streams was deprecated 03-Jan-2018 but this package still exists in 21c.

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

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	REVOKE_ADMIN_PRIVILEGE	REVOKE_REMOTE_ADMIN_ACCESS
GRANT_REMOTE_ADMIN_ACCESS

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);

TBD

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);

TBD

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