Oracle | XS_DATA_SECURITY

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

This package is protected by an ACCESSIBLE BY clause and can only be accessed through 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');

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

            *

      ERROR at line 1:

      ORA-06550: line 1, column 7:

      PLS-00904: insufficient privilege to access object XS_DATA_SECURITY_INT

      ORA-06550: line 1, column 7:

      PL/SQL: Statement ignored

Morgan's Library Page Footer

This site is maintained by Dan Morgan. Last Updated:

DBSecWorx