Getting an "ORA-31050: Access denied" exception when executing the DBMS_XDB_REPOS.getAclDocument() function and could use some help, please.
There is an existing resource (/home) in XDB. Was created in the distant past and I have no knowledge regarding it other than its existance. There does not appear to be an ACL associated with it.
If I execute DBMS_XDB_REPOS.getAclDocument() against /home, the function returns normally because there isn't any ACL associated with /home.
When I create a subfolder (/home/pete), an ACL (/home/pete_acl.xml), and associate the ACL to the subfolder, DBMS_XDB_REPOS.getAclDocument() raises the "ORA-31050: Access denied" exception when I try to retrieve the subfolder's ACL.
The /home/pete subfolder and the /home/pete_acl.xml ACL are both being created in XDB when I disable the DBMS_XDB_REPOS.getAclDocument() call. I connected to XDB with WinSCP using the WebDAV protocol and visually verified they were there.
.txt has been added to most file names to get them through the Attach functionality.
pete_xdb_test2.pks.txt
pete_xdb_test2.pkb.txt
driver2.sql.txt is, obviously, the driver to run the test.
driver2_d6.lst.txt is the output from the driver2.sql test run which includes system info and relevant database user and role info.
disp_sys_info.sql.txt is called by driver2.sql to get the system/user/role info.
pete_acl.xml is the created ACL downloaded via WinSCP.
Any help would be greatly appreciated.
Thank you in advance.