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!

How to find missing object privilege

Jocelyn_SimardMar 10 2016 — edited Apr 8 2016

Hi all,

We are deploying Oracle Windows Bundle Patch 11.2.0.4.160129.

One application broke after the patch was applied – it just crashes without an error message.

We found by experimenting that granting SELECT ANY DICTIONARY system privilege allow the application to work properly.

Now, I don't want to grant such a powerfull privilege and would rather find the missing object privilege on the dictionary.

I tried comparing ALL_OBJECTS with and without the SELECT ANY DICTIONARY grant but found no difference...

So the question is: How can I find out the missing grant at the object level?

Regards,

Jocelyn Simard

This post has been answered by unknown-7404 on Mar 10 2016

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on May 6 2016

Added on Mar 10 2016

#general-database-discussions

13 comments

2,187 views