Plan security allows you to give explicit rights to an SQL plan. When you give explicit rights to an SQL plan, that plan and its associated program can be executed without specific access rights to the tables or views accessed by that plan. However, any non-SQL statement executed from the same program is checked according to the security profile for the tables accessed by the native command.
You can administer SQL plan security by using SQL GRANT and REVOKE statements that use SQL security for table and views as discussed under Table Security.
SQL plan security can also be administered by using external security facilities. SQL plan security can therefore be combined with the external table security model to provide a single-source security model. We recommend that you administer plan security through external security.
|
Copyright © 2014 CA.
All rights reserved.
|
|