ORA-31050: Access Denied Trying to Create a Resource in XDB Repository
(Doc ID 762425.1)
Last updated on APRIL 29, 2020
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.1 and later
Information in this document applies to any platform.
When trying to create a resource in a folder which is owned by another user, it fails with error when done in a PL/SQL procedure, even if the XDBADMIN role has been granted.
retb := DBMS_XDB.createresource('/common/new.xml',
ERROR at line 1:
ORA-31050: Access denied
ORA-6512: at "XDB.DBMS_XDB", line 73
ORA-6512: at "TESTUSER.TEST", line 4
ORA-6512: at line 1
The error only occurs when trying to create a resource in a PL/SQL procedure. Creating the resource in SQL*Plus directly works:
retb := DBMS_XDB.createresource('/common/new2.xml',
PL/SQL procedure successfully completed.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document