Oracle Database Discussions

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!

Find the select privileges on a view and package

Karan KukrejaSep 12 2011 — edited Sep 12 2011

Hi All ,

I am looking for a query/view which i can query to find the users who have been granted access to the views.

I have some 100 views and I want to know the users who have access to each of the view.

Have queried many of the predefied views but I am unable to find the information.

Also , I need to find the users who have grants to the packages.which view to query ?

OS : SOlaris SPARC
Oracle Version : 11.1.0.7

Please suggest

Thanks and Regards
KK

Edited by: Kk on Sep 12, 2011 2:56 AM

This post has been answered by VenkatB on Sep 12 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 10 2011

Added on Sep 12 2011

#general-database-discussions

7 comments

2,702 views