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.
DDL
CREATE OR REPLACE TYPE ODCIVarchar2List FORCE
OID '0000000000000000000000000002121C' AS VARRAY(32767) OF VARCHAR2(4000);
/
Dependencies
CTX_DDL
RDF_APIS
SEM_RDFCTX_DR
CTX_QUERY
RDF_APIS_INTERNAL
SEM_RDFCTX_IR
DBMS_ISCHED
RDF_MATCH_IMPL_T
SEM_RDFSA_DR
DBMS_SCHEDULER
SDO_RDF
S_SDO_RDF_INFO
DRVDML
SDO_RDF_INTERNAL
S_SDO_RDF_INTERNAL
DRVLSB
SDO_RDF_JAVA_STP
S_SDO_RDF_QUERY
DRVPARX
SDO_SEM_INF_INTERNAL
S_SEM_RDFCTX_DR
PRLLIDX_CREATE
SEM_OLS
S_SEM_RDFSA_DR
Documented
No
First Available
Not Known
Security Model
Owned by SYS with EXECUTE granted to PUBLIC
Source
{ORACLE_HOME}/rdbms/admin/catodci.sql
Demo
Type Usage Demo
conn uwclass/uwclass@pdbdev
col program_id format a11
SELECT DISTINCT program_id
FROM airplanes
INTERSECT
SELECT *
FROM TABLE(sys.OdciVarchar2List('717', '727', '737', '747'));