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
CURRENT_USER
Dependencies
DBMS_LOB
DBMS_XSLPROCESSOR
URITYPE
DBMS_XDB_UTIL
DBMS_XSLPROCESSOR_LIB
UTL_FILE
DBMS_XMLDOM
URIFACTORY
UTL_RAW
DBMS_XMLPARSER
Documented
No
First Available
12.1
Security Model
Owned by XDB with EXECUTE granted to PUBLIC
Direct access to this package is prevented by means of an Accessible By clause.
This package may be protected with an ACCESSIBLE BY clause
dbms_clobutil.clob2url(
cl IN CLOB,
url IN VARCHAR2,
basedir IN VARCHAR2,
csid IN NUMBER);
conn / as sysdba
ALTER USER xdb IDENTIFIED BY xdb ACCOUNT UNLOCK;
exec xdb.dbms_clobutil.clob2url('Test', 'www.test.com', 'test', 1);
BEGIN xdb.dbms_clobutil.clob2url('Test', 'www.test.com', 'test', 1); END;
*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00904: insufficient privilege to access object DBMS_CLOBUTIL
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
ALTER USER xdb IDENTIFIED BY xdb ACCOUNT UNLOCK;
conn xdb/xdb
exec xdb.dbms_clobutil.clob2url('Test', 'www.test.com', 'test', 1);
BEGIN xdb.dbms_clobutil.clob2url('Test', 'www.test.com', 'test', 1); END;
*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00904: insufficient privilege to access object DBMS_CLOBUTIL
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored