Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

XML Repository : ORA-31050: Access denied

779210Jun 14 2010 — edited May 25 2011
Hi,

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 22 2011
Added on Jun 14 2010
6 comments
2,145 views