Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Grant Execute Privilege

798294May 17 2011 — edited May 17 2011
Dear Members,

I want to Grant Execute Privileges to all database Packages that apps owns. How can i do that?

Suppose we have 200 Packages under apps schema and instead of giving Grant Individually to all packages, i need a way to give execute privilege to all Packages that apps owns at Once.

I tried using 
grant execute any procedure to apps_dev
where apps_dev is a database account, but this will give access to all schemas which i don't want. I only want access to packages that apps account owns.


Thanks
Sandeep
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 14 2011
Added on May 17 2011
5 comments
3,827 views