December 2002
Intermediate to advanced
928 pages
85h 29m
English
Prior to Oracle8i, a stored procedure had its own set of privileges. Anyone using that stored procedure to access data used the privileges granted to the procedure, regardless of her own set of privileges.
Starting with Oracle8i, you can now create a function, procedure, package, object type, or Java code with an invoker rights clause. This clause causes the object to execute with the rights of the user invoking it, rather than the rights of the object itself.