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;