Oracle in a Nutshell

Calls

FUNCTION DMBS_XDB.getAclDocument (abspath IN VARCHAR); RETURN SYS.XMLTYPE;

Retrieves the ACL document from the XML document with a pathname of abspath.

FUNCTION DMBS_XDB.getPrivileges (res_path IN VARCHAR2) RETURN SYS.XMLTYPE;

Returns privileges granted to the current user on the XML document with the absolute path of res_path.

FUNCTION DMBS_XDB.changePrivileges (res_path IN VARCHAR2, ace IN XMLTYPE) RETURN PLS_INTEGER;

Adds the ace privilege to XML document with the absolute path of res_path. Returns a positive integer if the ACL was successfully modified.

FUNCTION DMBS_XDB.checkPrivileges (res_path IN VARCHAR2, privs IN XMLTYPE) RETURN PLS_INTEGER;

Checks to see if the XML document with the absolute path of res_path has privilege privs. Returns a positive integer if it does.

PROCEDURE DMBS_XDB.setacl (res_path IN VARCHAR2, acl_path IN VARCHAR2);

Sets the ACL (specified by acl) on the XML document with the absolute path of res_path to acl_path.

FUNCTION DMBS_XDB.AclCheckPrivileges (acl_path IN VARCHAR2, owner IN VARCHAR2, privs IN XMLTYPE) RETURN PLS_INTEGER;

Checks privs in the document owned by owner against acl_path. Returns a positive integer if all privileges were granted.

FUNCTION DMBS_XDB.LockResource (path IN VARCHAR2, depthzero IN BOOLEAN, shared IN BOOLEAN) RETURN BOOLEAN;

Creates a lock on XML resource path. If shared, the function will create a shared lock. depthzero is currently unsupported. Returns TRUE if the lock was obtained.

PROCEDURE DMBS_XDB.GetLockToken ...