Understanding roles in Oracle-stored procedures

May 21, 2008

One of the trickiest parts of Oracle's security model is the way that roles (collections of database privileges) interact with stored procedures, functions, and packages. Object privileges in Oracle can be granted directly to the user or indirectly via a role.

The article continues at http://www.builderau.com.au/program/oracle/soa/Understanding-roles-in-Oracle-stored-procedures/0,339028441,339288998,00.htm