Oracle | XS_DATA_SECURITY

Oracle XS_DATA_SECURITY_INT Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows

Purpose Real Application Security Policy Administrative Interface Internal

AUTHID DEFINER

Dependencies

DBMS_XDS_LIB	XS$INSTSET_INH	XS$OBJ
PLITBLM	XS$INSTSET_INH_KEY	XS$POLICY_PARAM
XS$ACL_PARAM	XS$INSTSET_LIST	XS$REALM_CONSTRAINT_LIST
XS$ATTR_SEC	XS$INSTSET_RULE	XS$REALM_CONSTRAINT_TYPE
XS$COLUMN_CONSTRAINT_LIST	XS$KEY_LIST	XS_ADMIN_INT
XS$COLUMN_CONSTRAINT_TYPE	XS$KEY_TYPE	XS_ADMIN_UTIL
XS$DSEC	XS$LIST	XS_DATA_SECURITY
XS$INSTSET_ACL	XS$NAME_LIST

Documented No

First Available Not known

Security Model Owned by SYS with no privileges granted

Direct access to this package is prevented by an Accessible By clause pointing to XS_DATA_SECURITY.

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

Subprograms

ADD_COLUMN_CONSTRAINTS	CREATE_POLICY	REMOVE_COLUMN_CONSTRAINTS
APPEND_REALM_CONSTRAINTS	DELETE_ACL_PARAMETER	REMOVE_OBJECT_POLICY
APPLY_OBJECT_POLICY	DELETE_POLICY	REMOVE_REALM_CONSTRAINTS
CREATE_ACL_PARAMETER	ENABLE_DISABLE_OBJECT_POLICY	SET_DESCRIPTION

ADD_COLUMN_CONSTRAINTS

Add a column constraint to data security

Overload 1 xs_data_security_int.add_column_constraints( policy IN VARCHAR2, column_constraint IN sys.xs$column_constraint_type);

TBD

Add a list of column constraints to data security

Overload 2 xs_data_security_int.add_column_constraints( policy IN VARCHAR2, column_constraint_list IN sys.xs$column_constraint_list);

TBD

APPEND_REALM_CONSTRAINTS

Add a realm constraint to data security

Overload 1 xs_data_security_int.add_realm_constraints( policy IN VARCHAR2, realm_constraint IN sys.xs$realm_constraint_type);

TBD

Add a list of realm constraints to data security

Overload 2 xs_data_security_int.add_realm_constraints( policy IN VARCHAR2, realm_constraint_list IN sys.xs$realm_constraint_list);

TBD

APPLY_OBJECT_POLICY

Apply an XDS policy on a table xs_data_security_int.apply_object_policy( policy IN VARCHAR2, schema IN VARCHAR2, object IN VARCHAR2, row_acl IN BOOLEAN, owner_bypass IN BOOLEAN, statement_types IN VARCHAR2, aclmv IN VARCHAR2, invoker IN VARCHAR2);

TBD

CREATE_ACL_PARAMETER

Create an ACL parameter xs_data_security_int.create_acl_parameter( policy IN VARCHAR2, parameter IN VARCHAR2, param_type IN NUMBER);

TBD

CREATE_POLICY

Create a data security policy xs_data_security_int.create_policy( name IN VARCHAR2, realm_constraint_list IN sys.xs$realm_constraint_list, column_constraint_list IN sys.xs$column_constraint_list, description IN VARCHAR2);

TBD

DELETE_ACL_PARAMETER

Delete an ACL parameter xs_data_security_int.delete_acl_parameter( policy IN VARCHAR2, parameter IN VARCHAR2, delete_option IN BINARY_INTEGER);

TBD

DELETE_POLICY

Delete a data security policy xs_data_security_int.delete_policy( policy IN VARCHAR2, delete_option IN BINARY_INTEGER);

TBD

ENABLE_DISABLE_OBJECT_POLICY

Enable or disable a table XDS policy xs_data_security_int.enable_disable_object_policy( policy IN VARCHAR2, schema IN VARCHAR2, object IN VARCHAR2, enable IN BOOLEAN, invoker IN VARCHAR2);

TBD

REMOVE_COLUMN_CONSTRAINTS

Remove all data security column constraints xs_data_security_int.remove_column_constraints(policy IN VARCHAR2);

TBD

REMOVE_OBJECT_POLICY

Remove an XDS policy from a table xs_data_security_int.remove_object_policy( policy IN VARCHAR2, schema IN VARCHAR2, object IN VARCHAR2, invoker IN VARCHAR2);

TBD

REMOVE_REALM_CONSTRAINTS

Remove all realm constraints xs_data_security_int.remove_realm_constraints(policy IN VARCHAR2);

TBD

SET_DESCRIPTION

Set a data security policy description xs_data_security_int.set_description( policy IN VARCHAR2, description IN VARCHAR2);

exec xs_data_security_int.set_description('UWDSPOL', 'UW Test Policy');

           *

      PLS-00904: insufficient privilege to access object XS_DATA_SECURITY_INT

Morgan's Library Page Footer

This site is maintained by Daniel Morgan. Last Updated: