Privileges for registering an XML schema

From: Schauss, Peter (ESS) <"Schauss,>
Date: Tue, 28 Aug 2012 14:56:54 +0000
Message-ID: <8AE45871F749FC4CBBE053CF2F8A493C0CFB390F_at_XMBVAG74.northgrum.com>



This is Oracle 11.2.0.3 running on AIX 5.3.

Following the example in the "Using Oracle XML DB" I run:

BEGIN
DBMS_XMLSCHEMA.registerSchema(
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 table
create any directory
xdbadmin
create view
create type

MOS says that xdbadmin is the only privilege I need to run this stored procedure. What am I missing?

Thanks,
Peter Schauss

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Aug 28 2012 - 09:56:54 CDT

Original text of this message