Oracle | DBMS_XDS

Oracle DBMS_XDS_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 Undocumented internal XDS support that is part of database security.

AUTHID DEFINER

Dependencies

DBMS_ASSERT	DBMS_UTILITY	XS_ADMIN_UTIL
DBMS_RLS	DBMS_XDS	XS_DATA_SECURITY
DBMS_STANDARD	XS$OLAP_POLICY	XS_DATA_SECURITY_UTIL

Documented No

First Available 18.1

Security Model Owned by SYS with no privileges granted

Direct access to this package is prevented by means of an Accessible By clause.

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

Subprograms

ALTER_STATIC_ACL_REFRESH	DROP_XDS	SCHEDULE_STATIC_ACL_REFRESH
DISABLE_OLAP_POLICY	ENABLE_OLAP_POLICY	SET_TRACE_LEVEL
DISABLE_XDS	ENABLE_XDS	XDS$REFRESH_STATIC_ACL
DROP_OLAP_POLICY	PURGE_ACL_REFRESH_HISTORY

ALTER_STATIC_ACL_REFRESH

Undocumented dbms_xds_int.alter_static_acl_refresh( schema_name IN VARCHAR2, table_name IN VARCHAR2, refresh_mode IN VARCHAR2);

TBD

DISABLE_OLAP_POLICY

Undocumented dbms_xds_int.disable_olap_policy( schema_nm IN VARCHAR2, logical_nm IN VARCHAR2, def_schema IN VARCHAR2);

TBD

DISABLE_XDS

Undocumented dbms_xds_int.disable_xds( object_schema IN VARCHAR2, object_name IN VARCHAR2, policy_name IN VARCHAR2);

TBD

DROP_OLAP_POLICY

Undocumented dbms_xds_int.drop_olap_policy( schema_nm IN VARCHAR2, logical_nm IN VARCHAR2, def_schema IN VARCHAR2);

TBD

DROP_XDS

Undocumented dbms_xds_int.drop_xds( object_schema IN VARCHAR2, object_name IN VARCHAR2, policy_name IN VARCHAR2);

TBD

ENABLE_OLAP_POLICY

Undocumented dbms_xds_int.enable_olap_policy( schema_nm IN VARCHAR2, logical_nm IN VARCHAR2, policy_nm IN VARCHAR2, overwrite IN BOOLEAN, def_schema IN VARCHAR2);

TBD

ENABLE_XDS

Undocumented dbms_xds_int.enable_xds( object_schema IN VARCHAR2, object_name IN VARCHAR2, enable_option IN BINARY_INTEGER, policy_name IN VARCHAR2, usermv_name IN VARCHAR2);

TBD

PURGE_ACL_REFRESH_HISTORY

Purges ACL refresh history with respect to the identified object dbms_xds_int.purge_acl_refresh_history( object_schema IN VARCHAR2, object_name IN VARCHAR2, purge_date IN DATE);

sys@pdbdev as sysdba

      

      exec dbms_xds_int.purge_acl_refresh_history('SCOTT', 'EMPCOPY', SYSDATE+1/60);

      BEGIN dbms_xds_int.purge_acl_refresh_history('SCOTT', 
      'EMPCOPY', SYSDATE+1/60); END;

      *

      ERROR at line 1:

      ORA-06550: line 1, column 7:

      PLS-00904: insufficient privilege to access object DBMS_XDS_INT

      ORA-06550: line 1, column 7:

      PL/SQL: Statement ignored

SCHEDULE_STATIC_ACL_REFRESH

Undocumented dbms_xds_int.schedule_static_acl_refresh( schema_name IN VARCHAR2, table_name IN VARCHAR2, start_date IN TIMESTAMP WITH TIME ZONE, repeat_interval IN VARCHAR2, comments IN VARCHAR2);

TBD

SET_TRACE_LEVEL

Likely enables a 10046 trace on a named object dbms_xds_int.set_trace_level( schema_name IN VARCHAR2, table_name IN VARCHAR2, level IN NUMBER);

SQL> exec dbms_xds_int.set_trace_level('SCOTT', 'EMP', 12);

      BEGIN dbms_xds_int.set_trace_level('SCOTT', 'EMP', 
      12); END;

      *

      ERROR at line 1:

      ORA-06550: line 1, column 7:

      PLS-00904: insufficient privilege to access object DBMS_XDS_INT

      ORA-06550: line 1, column 7:

      PL/SQL: Statement ignored

XDS$REFRESH_STATIC_ACL

Undocumented dbms_xds_int.xds$refresh_static_acl( schema_name IN VARCHAR2, table_name IN VARCHAR2, mview_name IN VARCHAR2, job_name IN VARCHAR2);

TBD