Oracle | XML_SCHEMA_NAME

Oracle XML_SCHEMA_NAME_PRESENT 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

AUTHID DEFINER

Dependencies

ALL_ANNOTATION_TEXT_METADATA	ALL_STREAMS_NEWLY_SUPPORTED	MDX_ODBO_HIERARCHIES
ALL_OBJECTS	ALL_STREAMS_UNSUPPORTED	MDX_ODBO_LEVELS
ALL_OBJECTS_AE	ALL_WM_VERSIONED_TABLES	MDX_ODBO_MEASURES
ALL_PROBE_OBJECTS	DV$OUT	MDX_ODBO_PROPERTIES
ALL_SDO_CSW_SERVICE_INFO	MDX_ODBO_CUBES	USER_SDO_CSW_SERVICE_INFO
ALL_SDO_INDEX_HISTOGRAM	MDX_ODBO_DIMENSIONS	USER_SDO_INDEX_HISTOGRAM
ALL_STREAMS_COLUMNS

Documented No

First Available 10.1

Security Model Owned by SYS with no privileges granted

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

IS_SCHEMA_PRESENT

Undocumented - but here's the source code. Some of the slickest coding I've ever seen. <g>

This code is based on sample code found in catxdbdv.sql in the 12c Beta FUNCTION is_schema_present(objname IN VARCHAR2, userno IN NUMBER) RETURN NUMBER AS BEGIN RETURN 0; END;

SELECT xml_schema_name_present.is_schema_present('Larry Ellison', 1)

      FROM dual;

      

      
      XML_SCHEMA_NAME_PRESENT.IS_SCHEMA_PRESENT('LARRYELLISON',1)

      -----------------------------------------------------------

                                                                0

This demo code was extracted from cdcore.sql and reformatted for clarity AND 1 = ( SELECT /*+ NO_MERGE */ xml_schema_name_present.is_schema_present(o.name, u2.id2) id1 FROM ( SELECT /*+ NO_MERGE */ userenv('SCHEMAID') id2 FROM dual) u2));