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.
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);
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);
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;