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