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!

I want to find all the objects for which I don't have access in oracle database (or permissions )

RajendraAug 28 2017 — edited Aug 29 2017

Hi All,

Could you guys please help me finding all the objects for which I don't have access in oracle database for a particular schema.

For example I am user A and I want to find all the objects name in schema B for which I don't have access.

Please let me know if you need any other details.

Thanks,

Rajendra Yadav

This post has been answered by Frank Kulash on Aug 28 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 26 2017
Added on Aug 28 2017
6 comments
4,293 views