DBAzine.com

Sections

Personal tools

You are not logged in
Log in
Join

You are here: Home » 10g » Oracle10g Articles » Storing XML Data » Access Control Lists on Files copied in via Web Folders

Who Are You?

I am a:
[ Results | Polls ]
Votes : 3549

Comment

Above in this comment thread: Storing XML Data » Access Control Lists on Files copied in via Web Folders

Access Control Lists on Files copied in via Web Folders

Posted by mscardina at 2005-12-16 04:33 PM

Your "read" ACL should restrict updating or replacing the original document. It, of course, does not prevent AN_OTHER from editing the document in his version of Word. I suggest that you query the privledges granted to AN_OTHER as follows:

SELECT DBMS_XDB.getPrivileges('/my_folder').getClobVal() FROM DUAL;

If the result shows AN_OTHER only has read privledges yet he can update the repository, then there maybe a configuration issue. WEBDAV support is built on top of the XML functionality that this article covers. For additional help in this area, I suggest you visit theOTN XMLDB Forum at http://forums.oracle.com/forums/forum.jspa?forumID=34.

Transaction Management
Reduce downtime and increase repeat sales by improving end-user experience.
Free White Paper

Database Recovery
Feeling the increased demands on data protection and storage requirements?
Download Free Report!