Understanding roles in Oracle stored procedures

Thursday May 17th 2007 by DatabaseJournal.com Staff

Permissions in Oracle granted indirectly via roles are not available when compiling stored procedures, functions, and packages. Direct grants are required when creating these objects in the database. Learn more details in this Oracle tip.

[From Builder.com]

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://builder.com.com/5100-6388_14-6183799.html?tag=sc

Mobile Site | Full Site