Skip to Main Content
Oracle in a Nutshell
book

Oracle in a Nutshell

by Rick Greenwald, David C. Kreines
December 2002
Intermediate to advanced content levelIntermediate to advanced
928 pages
85h 29m
English
O'Reilly Media, Inc.
Content preview from 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 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Internals

Oracle Internals

Donald K. Burleson
Oracle PL/SQL

Oracle PL/SQL

Lewis Cunningham
Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Rick Greenwald, Robert Stackowiak, Jonathan Stern

Publisher Resources

ISBN: 0596003366Errata Page