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