Oracle XS_ADMIN_UTIL

Oracle XS_ADMIN_UTIL_INT 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 Real Application Security Internal Utilities

AUTHID DEFINER

Dependencies

DBMS_STANDARD	XS$ACE	XS_ADMIN_INT
PLITBLM	XS$ACE_PRIV	XS_ADMIN_UTIL
USER$	XS$ACL	XS_MTCACHE_INT

Documented No

First Available 12.2

Security Model Owned by SYS with no privileges granted

Source {ORACLE_HOME}/rdbms/admin/prvtutils.plb

Subprograms

GRANT_SYSTEM_PRIVILEGE

REMOVE_DBUSER_ACES

REVOKE_SYSTEM_PRIVILEGE

GRANT_SYSTEM_PRIVILEGE

Grants a RAS System Privilege xs_admin_util_int.grant_system_privilege( priv_name IN VARCHAR2, user_name IN VARCHAR2, user_type IN BINARY_INTEGER := xs_admin_util.ptype_db, schema IN VARCHAR2 := NULL);

exec xs_admin_util_int.grant_system_privilege('ADMINISTER_SESSION', 'C##SH');

REMOVE_DBUSER_ACES

Remove a database user Access Control Entry (ACE) xs_admin_util_int.remove_dbuser_aces(user_name IN VARCHAR2);

exec xs_admin_util_int.remove_dbuser_aces('C##SH');

REVOKE_SYSTEM_PRIVILEGE

Revoke a RAS System Privilege xs_admin_util_int.revoke_system_privilege( priv_name IN VARCHAR2, user_name IN VARCHAR2, user_type IN BINARY_INTEGER := xs_admin_util.ptype_db, schema IN VARCHAR2 := NULL);

exec xs_admin_util_int.revoke_system_privilege('ADMINISTER_SESSION', 'C##SH');

Morgan's Library Page Footer

This site is maintained by Dan Morgan. Last Updated:

DBSecWorx