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.
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-lReceived on Tue Aug 28 2012 - 09:56:54 CDT