Oracle | DBMS_STREAMS

Oracle DBMS_STREAMS_AUTH Version 21c

General Information

Library Note

Morgan's Library Page Header

Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.

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