Oracle | DBMS

Oracle DBMS_XDBZ0 Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

Purpose XDB Zecurity Utilities

AUTHID CURRENT_USER

Dependencies

ALL_POLICIES	DBMS_XDBUTIL_INT	SECURITY_LIB
DBMS_ASSERT	DBMS_XDBZ	SETMODFLG
DBMS_RLS	DBMS_XDBZ_LIB	USER_POLICIES
DBMS_SQL	DUAL	XDB$NAMESUFF_SEQ
DBMS_STANDARD	ISXMLTYPETABLE	XMLTYPE
DBMS_XDBT

Documented No

Exceptions

Error Code	Reason

First Available Not known

Security Model Owned by XDB with EXECUTE granted to PUBLIC

Source {ORACLE_HOME}/rdbms/admin/prvtxdz0.plb
{ORACLE_HOME}/rdbms/admin/prvtxdbz.plb

Subprograms

dbmsxdbt_int.sql get_username code

CHECKPRIVRLS_DELETEPF	DISABLE_HIERARCHY_INTERNAL	IS_HIERARCHY_ENABLED_INTERNAL
CHECKPRIVRLS_DELETEPROPF	ENABLE_HIERARCHY_INTERNAL	IS_HIERARCHY_ENABLED_TRIG
CHECKPRIVRLS_INSERTPF	GENERATE_TRGNM	MIGRATE_PITRIG
CHECKPRIVRLS_SELECTPF	GENERATE_TRGNMDL	SETMODFLG_INTERNAL
CHECKPRIVRLS_SELECTPROPF	GET_USERNAME	SET_DELTA_CALC_INLINE_TRIGFLAG
CHECKPRIVRLS_UPDATEPF	GET_VALID_ACL	TRUNCATE_NAME
CHECKPRIVRLS_UPDATEPROPF	INITXDBRESCONFIG	UPDATE_TABLE_DEPENDANT_FLAGS
CHECKWORKSPACE_PF	INITXDBSECURITY

CHECKPRIVRLS_DELETEPF

Undocumented dbms_xdbz0.checkPrivRls_deletePF( object_schema IN VARCHAR2, object_name IN VARCHAR2) RETURN VARCHAR2;

TBD

CHECKPRIVRLS_DELETEPROPF

Undocumented dbms_xdbz0.checkPrivRls_deleteProPF( object_schema IN VARCHAR2, object_name IN VARCHAR2) RETURN VARCHAR2;

TBD

CHECKPRIVRLS_INSERTPF

Undocumented dbms_xdbz0.checkPrivRls_insertPF( object_schema IN VARCHAR2, object_name IN VARCHAR2) RETURN VARCHAR2;

TBD

CHECKPRIVRLS_SELECTPF

Undocumented dbms_xdbz0.checkPrivRls_selectPF( object_schema IN VARCHAR2, object_name IN VARCHAR2) RETURN VARCHAR2;

TBD

CHECKPRIVRLS_SELECTPROPF

Undocumented dbms_xdbz0.checkPrivRls_selectProPF( object_schema IN VARCHAR2, object_name IN VARCHAR2) RETURN VARCHAR2;

TBD

CHECKPRIVRLS_UPDATEPF

Undocumented dbms_xdbz0.checkPrivRls_updatePF( object_schema IN VARCHAR2, object_name IN VARCHAR2) RETURN VARCHAR2;

TBD

CHECKPRIVRLS_UPDATEPROPF

Undocumented dbms_xdbz0.checkPrivRls_updateProPF( object_schema IN VARCHAR2, object_name IN VARCHAR2) RETURN VARCHAR2;

TBD

CHECKWORKSPACE_PF

Undocumented dbms_xdbz0.checkWorkspace_pf( object_schema IN VARCHAR2, object_name IN VARCHAR2) RETURN VARCHAR2;

TBD

DISABLE_HIERARCHY_INTERNAL

Undocumented dbms_xdbz0.disable_hierarchy_internal( object_schema IN VARCHAR2, object_name IN VARCHAR2, hierarchy_type IN BINARY_INTEGER, delete_old_versions IN BOOLEAN);

TBD

ENABLE_HIERARCHY_INTERNAL

Undocumented dbms_xdbz0.enable_hierarchy_internal( object_schema IN VARCHAR2, object_name IN VARCHAR2, hierarchy_type IN BINARY_INTEGER, schemareg IN BOOLEAN);

TBD

GENERATE_TRGNM

Undocumented dbms_xdbz0.generate_trgnm( object_schema IN VARCHAR2, object_name IN VARCHAR2) RETURN VARCHAR2;

TBD

GENERATE_TRGNMDL

Undocumented dbms_xdbz0.generate_trgnMdl( object_schema IN VARCHAR2, object_name IN VARCHAR2) RETURN VARCHAR2;

TBD

GET_USERNAME

Undocumented dbms_xdbz0.get_username( userid IN RAW, username OUT VARCHAR2);

TBD

GET_VALID_ACL

Undocumented dbms_xdbz0.get_valid_acl(acloid IN RAW) RETURN sys.xml_type;

TBD

INITXDBRESCONFIG

Undocumented dbms_xdbz0.initXDBResConfig;

exec xdb.dbms_xdbz0.initXDBResConfig;

      

      PL/SQL procedure successfully completed.

INITXDBSECURITY

Undocumented dbms_xdbz0.initXDBSecurity;

exec xdb.dbms_xdbz0.initXDBSecurity;

      

      PL/SQL procedure successfully completed.

IS_HIERARCHY_ENABLED_INTERNAL

Undocumented dbms_xdbz0.is_hierarchy_enabled_internal( obj_schema IN VARCHAR2, obj_name IN VARCHAR2, hierarchy_type IN BINARY_INTEGER) RETURN BOOLEAN;

TBD

IS_HIERARCHY_ENABLED_TRIG

Undocumented dbms_xdbz0.is_hierarchy_enabled_trig( obj_schema IN VARCHAR2, obj_name IN VARCHAR2) RETURN BOOLEAN;

TBD

MIGRATE_PITRIG

Undocumented dbms_xdbz0.migrate_piTrig;

exec xdb.dbms_xdbz0.migrate_piTrig;

      

      PL/SQL procedure successfully completed.

SETMODFLG_INTERNAL

Undocumented dbms_xdbz0.setModelFlag_internal( object_schema IN VARCHAR2, object_name IN VARCHAR2, enable_flag IN BINARY_INTEGER);

TBD

SET_DELTA_CALC_INLINE_TRIGFLAG

Undocumented dbms_xdbz0.set_delta_calc_inline_trigflag( tablename IN VARCHAR2, tableschema IN VARCHAR2, flag IN BOOLEAN, schemareg IN BOOLEAN);

TBD

TRUNCATE_NAME

Undocumented dbms_xdbz0.truncate_name( object IN VARCHAR2, suffix IN VARCHAR2, num_bytes IN BINARY_INTEGER) RETURN VARCHAR2;

TBD

UPDATE_TABLE_DEPENDANT_FLAGS

Undocumented dbms_xdbz0.update_table_dependant_flags( tablename IN VARCHAR2, tableschema IN VARCHAR2, flag IN BINARY_INTEGER);

TBD