Skip to Main Content

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 ANY PROCEDURE

894936Feb 27 2013 — edited Feb 28 2013
hI ,

How do we check Privileges for all users whether grant privilege is given or not?

I tried to check
select * form all_users

Select * from dict where table_name like '%PRIV%'
SELECT *
  FROM all_tab_privs
  WHERE table_name in (select  object_name from  user_objects where object_type = 'PROCEDURE')

I want to check for all users whether we have granted privileges or not.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 28 2013
Added on Feb 27 2013
2 comments
320 views