Oracle | DBMS_STREAMS

Oracle DBMS_STREAMS_AUTH Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows

Purpose Manage privileges needed for streams administration

Streams was deprecated 03-Jan-2018 but this package still exists in 23ai.

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