Oracle DBMS_XDBZ
Version 19.2.0.1

General Information
Library Note Morgan's Library Page Header
For how many years have you been working with physical servers that are starving your database of the memory necessary to deploy important new performance features such as the Result Cache, Memoptimize Pool, In-Memory Aggregation, In-Memory Column Store, and Full Database Caching? Too long? Contact me to learn how to improve all queries ... not just some queries.
Purpose XDB Zecurity Utilities
AUTHID CURRENT_USER
Constants
Name Data Type Value
Name Format
NAME_FORMAT_SHORT PLS_INTEGER 1
NAME_FORMAT_DISTINGUISHED PLS_INTEGER 2
NAME_FORMAT_APPLICATION PLS_INTEGER 5
Enable
ENABLE_CONTENTS PLS_INTEGER 1
ENABLE_RESMETADATA PLS_INTEGER 2
ENABLE_VERSION PLS_INTEGER 4
ENABLE_LINKS PLS_INTEGER 8
Is Enabled
IS_ENABLED_CONTENTS PLS_INTEGER 1
IS_ENABLED_RESMETADATA PLS_INTEGER 2
IS_ENABLED_VERSION PLS_INTEGER 4
Disable & Skip
SKIP_SYSCONSACL_FLG PLS_INTEGER 0
DISABLE_VERSION PLS_INTEGER 1
DISABLE_ALL PLS_INTEGER 2
Application
APPLICATION_USER PLS_INTEGER 0
APPLICATION_ROLE PLS_INTEGER 1
Delete App
DELETE_APP_NOFORCE PLS_INTEGER 0
DELETE_APP_FORCE PLS_INTEGER 1
Mode Membership
MODE_MEMBERSHIP_ADD PLS_INTEGER 0
MODE_MEMBERSHIP_DELETE PLS_INTEGER 1
Dependencies
DBMS_ASSERT DBMS_XDBUTIL_INT IS_VPD_ENABLED
DBMS_METADATA_UTIL DBMS_XDBZ0 SECURITY_LIB
DBMS_STREAMS_CONTROL_ADM DBMS_XDB_ADMIN XDB_PI_TRIG
DBMS_XDB DUAL  
Documented Yes
First Available Not Known
Security Model Owned by XDB with EXECUTE granted to PUBLIC
Source {ORACLE_HOME}/rdbms/admin/dbmsxdbz.sql
Subprograms
 
DISABLE_HIERARCHY
Disables XDB Hierarchy for a particular xmltype table/view dbms_xdbz.disable_hierarchy(
object_schema       IN VARCHAR2,
object_name         IN VARCHAR2,
hierarchy_type      IN PLS_INTEGER := DISABLE_ALL,
delete_old_versions IN BOOLEAN     := FALSE);
PRAGMA SUPPLEMENTAL_LOG_DATA(disable_hierarchy, AUTO_WITH_COMMIT);
TBD
 
ENABLE_HIERARCHY
Enables XDB Hierarchy for a particular xmltype table/view dbms_xdbz.enable_hierarchy(
object_schema  IN VARCHAR2,
object_name    IN VARCHAR2,
hierarchy_type IN PLS_INGTEGER := ENABLE_CONTENTS,
schemareg      IN BOOLEAN      := FALSE);
PRAGMA SUPPLEMENTAL_LOG_DATA(enable_hierarchy, AUTO_WITH_COMMIT);
TBD
 
GET_ACLOID
Get's an ACL OID given the XDB Hierarchy path for the ACL Resource dbms_xdbz.get_acloid(
aclpath IN  VARCHAR2,
acloid  OUT RAW)
RETURN BOOLEAN;
TBD
 
GET_USERID
Retrieves the userid for the given user name dbms_xdbz.get_userid(
username IN  VARCHAR2,
userid   OUT RAW,
format   IN  PLS_INTEGER := NAME_FORMAT_SHORT)
RETURN BOOLEAN;
DECLARE
 outVal VARCHAR2(30);
 retVal BOOLEAN;
BEGIN
  retVal := xdb.dbms_xdbz.get_userid('C##SH', outVal);
  dbms_output.put_line(outVal);
END;
/
00000069

PL/SQL procedure successfully completed.
 
IS_HIERARCHY_ENABLED
Checks if the XDB Hierarchy is enabled for a given xmltype table/view dbms_xdbz.is_hierarchy_enabled(
object_schema  IN VARCHAR2,
object_name    IN VARCHAR2,
hierarchy_type IN PLS_INTEGER := IS_ENABLED_CONTENTS)
RETURN BOOLEAN;
TBD
 
PURGELDAPCACHE
Purges LDAP nickname cache dbms_xdbz.purgeLdapCache RETURN BOOLEAN;
BEGIN
  IF xdb.dbms_xdbz.purgeLdapCache THEN
    dbms_output.put_line('T');
  ELSE
    dbms_output.put_line('F');
  END IF;
END;
/
F
 
VALIDATEACL
Validates the security class, specified roles, custom privs, parent ACL security class of an ACL dbms_xdbz.validateACL(
acloid     IN RAW,
skip_scacl IN PLS_INTEGER := SKIP_SYSCONSACL_FLG);
TBD
 
VALIDATEFUSIONACL
For an ACL chain validates the system constraining ACL, non-system constraining ACL, constraining relationship, if any, between a parent and child ACL dbms_xdbz.validateFusionACL(acloid IN RAW);
TBD

Related Topics
Built-in Functions
Built-in Packages
DBMS_XDBT
What's New In 18cR3
What's New In 19cR2

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