Oracle | XS_SECURITY

Oracle XS_SECURITY_CLASS Version 21c

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 Security class administrative interface

AUTHID CURRENT_USER

Dependencies

DBMS_SFW_ACL_ADMIN	XS$PRIVILEGE_LIST	XS_ADMIN_UTIL
PLITBLM	XS_ADMIN_INT	XS_SECURITY_CLASS_INT
XS$NAME_LIST

Documented No

First Available Not known

Pragma PRAGMA SUPPLEMENTAL_LOG_DATA(default, AUTO);

Security Model Owned by SYS with EXECUTE granted to DBSFWUSER and PUBLIC

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

Subprograms

ADD_IMPLIED_PRIVILEGES	CREATE_SECURITY_CLASS	REMOVE_PARENTS
ADD_PARENTS	DELETE_SECURITY_CLASS	REMOVE_PRIVILEGES
ADD_PRIVILEGES	REMOVE_IMPLIED_PRIVILEGES	SET_DESCRIPTION

ADD_IMPLIED_PRIVILEGES

Add an implied privilege

Overload 1 xs_security_class.add_implied_privileges( sec_class IN VARCHAR2, priv IN VARCHAR2, implied_priv IN VARCHAR2);

TBD

Add a list of implied privileges

Overload 2 xs_security_class.add_implied_privileges( sec_class IN VARCHAR2, priv IN VARCHAR2, implied_priv_list IN sys.xs$name_list);

TBD

ADD_PARENTS

Add a parent security classes

Overload 1 xs_security_class.add_parents( sec_class IN VARCHAR2, parent IN VARCHAR2);

TBD

Add a list of parent security classes

Overload 2 xs_security_class.add_parents( sec_class IN VARCHAR2, parent_list IN sys.xs$name_list);

TBD

ADD_PRIVILEGES

Add a privilege to existing list of privileges (if any) of the security class

Overload 1 xs_security_class.add_privileges( sec_class IN VARCHAR2, priv IN VARCHAR2, implied_priv_list IN sys.xs$name_list := NULL, description IN VARCHAR2 := NULL);

TBD

Add a list of privileges to existing list of privileges (if any) of the security class

Overload 2 xs_security_class.add_privileges( sec_class IN VARCHAR2, priv_list IN sys.xs$privilege_list);

TBD

CREATE_SECURITY_CLASS

Create a security class xs_security_class.create_security_class( name IN VARCHAR2, priv_list IN sys.xs$privilege_list, parent_list IN sys.xs$name_list := NULL, description IN VARCHAR2 := NULL);

TBD

DELETE_SECURITY_CLASS

Delete the security class xs_security_class.delete_security_class( sec_class IN VARCHAR2, delete_option IN PLS_INTEGER := xs_admin_util.default_option);

TBD

REMOVE_IMPLIED_PRIVILEGES

Remove single implied privilege

Overload 1 xs_security_class.remove_implied_privileges( sec_class IN VARCHAR2, priv IN VARCHAR2, implied_priv IN VARCHAR2);

TBD

Remove a list of implied privileges

Overload 2 xs_security_class.remove_implied_privileges( sec_class IN VARCHAR2, priv IN VARCHAR2, implied_priv_list IN sys.xs$name_list);

TBD

Remove all implied privileges

Overload 3 xs_security_class.remove_implied_privileges( sec_class IN VARCHAR2, priv IN VARCHAR2);

TBD

REMOVE_PARENTS

Remove all parent security classes

Overload 1 xs_security_class.remove_parents(sec_class IN VARCHAR2);

TBD

Remove a parent security class

Overload 2 xs_security_class.remove_parents( sec_class IN VARCHAR2, parent IN VARCHAR2);

TBD

Remove a list of parent security classes

Overload 3 xs_security_class.remove_parents( sec_class IN VARCHAR2, parent_list IN sys.xs$name_list);

TBD

REMOVE_PRIVILEGES

Remove a security class form all parents

Overload 1 xs_security_class.remove_privileges(sec_class IN VARCHAR2);

TBD

Remove a privilege from the security (if the privilege is present)

Overload 2 xs_security_class.remove_privileges( sec_class IN VARCHAR2, priv IN VARCHAR2);

TBD

Remove a list of privileges from the security (if the privileges are present)

Overload 3 xs_security_class.remove_privileges( sec_class IN VARCHAR2, priv_list IN sys.xs$name_list);

TBD

SET_DESCRIPTION

Store a description of the security class xs_security_class.set_description( sec_class IN VARCHAR2, description IN VARCHAR2);

TBD