Oracle | XS_ADMIN_UTIL

Oracle XS_ADMIN_UTIL_INT 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 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