Oracle | DBMS_XSTREAM

Oracle DBMS_XSTREAM_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 Grants the privileges needed by a user to be an administrator for Xstreams Optionally generates a script whose execution has the same effect.

AUTHID CURRENT_USER

Dependencies

DBMS_LOGREP_UTIL	DBMS_STREAMS_AUTH	DBMS_XSTREAM_AUTH_IVK
DBMS_STANDARD

Documented Yes

First Available Not Known

Security Model Owned by SYS with no privileges granted.

The documentation states that the privilege is granted to the EXECUTE_CATALOG_ROLE but a query of the data dictionary does not substantiate that claim. A revoke from EXECUTE_CATALOG_ROLE is coded into c1201000.sql.

Source {ORACLE_HOME}/rdbms/admin/dbmsxstr.sql

Subprograms

GRANT_ADMIN_PRIVILEGE	REVOKE_ADMIN_PRIVILEGE	REVOKE_REMOTE_ADMIN_ACCESS
GRANT_REMOTE_ADMIN_ACCESS

GRANT_ADMIN_PRIVILEGE

Either grants the privileges needed by a user to be an XStream administrator directly, or generates a script that grants privileges dbms_xstream_auth.grant_admin_privilege( grantee IN VARCHAR2, privilege_type IN VARCHAR2 DEFAULT '*', grant_select_privileges IN BOOLEAN DEFAULT FALSE, do_grants IN BOOLEAN DEFAULT TRUE, file_name IN VARCHAR2 DEFAULT NULL, directory_name IN VARCHAR2 DEFAULT NULL, grant_optional_privileges IN VARCHAR2 DEFAULT NULL, container IN VARCHAR2 DEFAULT 'CURRENT');

exec dbms_xstream_auth.grant_admin_privilege('UWADMIN');

GRANT_REMOTE_ADMIN_ACCESS

Enables a remote XStream administrator to perform administrative actions at the local database by connecting using a database link dbms_xstream_auth.grant_remote_admin_access(grantee IN VARCHAR2);

exec dbms_xstream_auth.grant_remote_admin_access('UWADMIN');

REVOKE_ADMIN_PRIVILEGE

Either revokes XStream administrator
privileges from a user directly, or generates a script that revokes privileges dbms_xstream_auth.revoke_admin_privilege( grantee IN VARCHAR2, privilege_type IN VARCHAR2 DEFAULT '*', revoke_select_privileges IN BOOLEAN DEFAULT FALSE, do_revokes IN BOOLEAN DEFAULT TRUE, file_name IN VARCHAR2 DEFAULT NULL, directory_name IN VARCHAR2 DEFAULT NULL revoke_optional_privileges IN VARCHAR2 DEFAULT NULL, container IN VARCHAR2 DEFAULT 'CURRENT');

exec dbms_xstream_auth.revoke_admin_privilege('UWADMIN');

REVOKE_REMOTE_ADMIN_ACCESS

Disables a remote XStream administrator dbms_xstream_auth.revoke_remote_admin_access(grantee IN VARCHAR2);

exec dbms_xstream_auth.revoke_remote_admin_privilege('UWADMIN');