Privileges for registering an XML schema
Date: Tue, 28 Aug 2012 14:56:54 +0000
This is Oracle 22.214.171.124 running on AIX 5.3.
Following the example in the "Using Oracle XML DB" I run:
SCHEMAURL => 'http://local_host:8080/xdb/documentation/MY_Schema.xsd', SCHEMADOC => bfilename('XML_FILES','MY_Schema.xsd'), LOCAL => TRUE,
GENTYPES => TRUE,
GENTABLES => TRUE,
CSID => nls_charset_id('WE8ISO8859P1')); END; And get:
ORA-31061: XDB error: DBMS_XDBZ.ENABLE_HIERARCHY ORA-06512: at "XDB.DBMS_XDBZ0", line 131 ORA-06512: at "XDB.DBMS_XDBZ0", line 588 ORA-01031: insufficient privileges ORA-06512: at "XDB.DBMS_XDBZ", line 37 ORA-06512: at line 1 ORA-06512: at "XDB.DBMS_XMLSCHEMA_INT", line 37 ORA-06512: at "XDB.DBMS_XMLSCHEMA", line 65 ORA-06512: at "XDB.DBMS_XMLSCHEMA", line 136 ORA-06512: at line 2
My user has the following privileges:
create any directory
MOS says that xdbadmin is the only privilege I need to run this stored procedure. What am I missing?