Oracle DBMS_XDS_INT
Version 19c

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.0.0
Security Model Owned by SYS with no privileges granted
Source {ORACLE_HOME}/rdbms/admin/prvtrlsa.plb
Subprograms
 
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

Appears to be subject to an ACCESSIBLE BY clause
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

Appears to be subject to an ACCESSIBLE BY clause
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

Related Topics
Built-in Functions
Built-in Packages
DBMS_XDS
What's New In 19c
What's New In 20c-21c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx