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.
dbms_xdbutil_int.createSystemVirtualFolder(abspath IN VARCHAR2)
RETURN BOOLEAN;
-- from $ORACLE_HOME/rdbms/admin/catxdbst.sql and xdbu9202.sql
Rem Create OID virtual folder
Rem This step is repeatable.
DECLARE
ret BOOLEAN;
BEGIN
ret := dbms_xdbutil_int.createSystemVirtualFolder('/sys/oid');
IF ret THEN
dbms_xdb.setacl('/sys/oid', '/sys/acls/bootstrap_acl.xml');
END IF;
EXCEPTION
WHEN OTHERS THEN
ret := FALSE;
END;
/
COMMIT;
Rem Create ASM virtual folder
Rem This step is repeatable.
DECLARE
ret BOOLEAN;
BEGIN
ret := dbms_xdbutil_int.createSystemVirtualFolder('/sys/asm');
IF ret THEN
dbms_xdb.setacl('/sys/asm', '/sys/acls/all_owner_acl.xml');
END IF;
EXCEPTION
WHEN OTHERS THEN
ret := FALSE;
END;
/
dbms_xdbutil_int.get_tablespace_tab(
object_owner IN VARCHAR2,
object_name IN VARCHAR2,
object_subname IN VARCHAR2,
object_type IN VARCHAR2)
RETURN VARCHAR2;
dbms_xdbutil_int.instance_callout_imp(
obj_name IN VARCHAR2
obj_schema IN VARCHAR2
obj_type IN NUMBER
prepost IN BINARY_INTEGER
action OUT VARCHAR2
alt_name OUT VARCHAR2);
dbms_xdbutil_int.instance_export_action(
obj_name IN VARCHAR2
obj_schema IN VARCHAR2
obj_type IN NUMBER
prepost IN BINARY_INTEGER
action OUT VARCHAR2
alt_name OUT VARCHAR2
dbms_xdbutil_int.patchRepositoryResConfigList;
BEGIN dbms_xdbutil_int.patchRepositoryResConfigList; END;
*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "XDB.DBMS_XDBUTIL_INT", line 1051
ORA-06512: at line 1
dbms_xdbutil_int.system_info_exp(
prePost IN BINARY_INTEGER,
connectString OUT VARCHAR2,
version IN VARCHAR2,
new_block OUT BINARY_INTEGER);
RETURN VARCHAR2;
BEGIN
IF dbms_xdbutil_int.useSetLinkParentsNew THEN
dbms_output.put_line('Using ParentsNew');
ELSE
dbms_output.put_line('Not Using ParentsNew');
END IF;
END;
/ Not Using ParentsNew
dbms_xdbutil_int.XMLSchemaStripUsername(
schemadoc IN XMLTYPE,
username IN VARCHAR2)
RETURN CLOB;
conn xdb/xdb
set long 1000000
set pagesize 0
set linesize 131
col xml_out format a130
col xml_len format 999999
SELECT XMLTYPE(s.getclobval()) as xml_out
FROM xdb$schema s
WHERE rownum = 1;
SELECT MIN(rowid) FROM xdb$schema;
SELECT XMLTYPE(s.getclobval()) as xml_out
FROM xdb$schema s
WHERE rowid = 'AAANXLAACAAADecAAA';
SELECT LENGTH(XMLTYPE(s.getclobval())) as xml_len
FROM xdb$schema s
WHERE rowid = 'AAANXLAACAAADecAAA';
SELECT xdb.dbms_xdbutil_int.XMLSchemaStripUsername(XMLTYPE(s.getClobVal()), 'XDB') xml_out
FROM xdb$schema s
WHERE rowid = 'AAANXLAACAAADecAAA';
col xml_out format 999999
SELECT LENGTH(xdb.dbms_xdbutil_int.XMLSchemaStripUsername(XMLTYPE(s.getClobVal()), 'XDB')) xml_len
FROM xdb$schema s
WHERE rowid = 'AAANXLAACAAADecAAA';