Achieve better control with Oracle's grant execute security model

Thursday Aug 14th 2003 by DatabaseJournal.com Staff
Share:

Using the grant execute method, all data access code is encapsulated into Oracle stored procedures, and the end users are granted the ability to execute the code. Learn about the grant execute method in this article.

[From Builder.com]

In a previous article, I investigated Oracle grant security and examined the design issues surrounding the assignment of access privileges to users. I noted that one of the shortcomings of Oracle grant security is that it can be very difficult to maintain all access roles and assign the roles to end users.

To address these issues and simplify Oracle security, Oracle introduced the grant execute method. Using the grant execute method, all data access code is encapsulated into Oracle stored procedures, and the end users are granted the ability to execute the code.

The article continues at http://builder.com.com/5100-6388-5054064.html?tag=sc

Share:
Home
Mobile Site | Full Site
Copyright 2017 © QuinStreet Inc. All Rights Reserved