XML Repository : ORA-31050: Access denied
779210Jun 14 2010 — edited May 25 2011Hi,
I have a problem withs the XML Repository.
I want to create a Folder were only one user has access to, this user is only allowed to see the content of this folder and nothing else.
So far so good, I create this user (roles: connect, resources) and gave him all rights for this folder.
I've done it like this:
created a XML -->
<acl description="ALL TESTUSR"
xmlns="http://xmlns.oracle.com/xdb/acl.xsd"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://xmlns.oracle.com/xdb/acl.xsd
http://xmlns.oracle.com/xdb/acl.xsd">
<ace>
<principal>TESTUSR</principal>
<grant>true</grant>
<privilege>
<all/>
</privilege>
</ace>
</acl>
and than I used this code:
DECLARE
r BOOLEAN;
BEGIN
r:=DBMS_XDB.createFolder('/home/TESTUSR');
DBMS_XDB.setAcl('/home/TESTUSR', '/sys/acls/all_testusr_acl.xml');
COMMIT;
END;
/
But when I connect via FTP I get the following error message:
Response: ORA-31050: Access denied
Response: 550 End Error Response
Error: Failed to retrieve directory listing
Error: Connection closed by server
After I gave the xdbadmin role to my user, he can connect, but he has also the rights for the other folders.
Has anybody an idea what I'm doing wrote. Besides my bad english.
Thanks
Bastian