Oracle DBMS_XSTREAM_AUTH
Version 20c

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

Note: This page has been posted prior to the GA release of 20c. It will be completed once we have access to the release version.
AUTHID CURRENT_USER
Dependencies
ALL_USERS DBMS_STANDARD DBMS_XSTREAM_ADM_UTL
DBMS_ASSERT DBMS_STREAMS_AUTH DBMS_XSTREAM_AUTH_IVK
DBMS_LOGREP_UTIL DBMS_UTILITY  
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');

Related Topics
Built-in Functions
Built-in Packages
DBMS_XSTREAM_AUTH_IVK
What's New In 19c
What's New In 20c

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