Bug when viewing privileges in Browser?

[Patrick Holmes]

When connected as a DBA, I can not see some grants to users/roles for an object. For example, I have a function in a schema called CASEM that is granted to user "VIRTUAL_OFFICE". If I am logged in as CASEM, I can see the grant in the Browswer. However, if I am logged in as myself with the DBA role, I can not see that grant. For another example, I have a table HEALTH_PROFS which is granted to 13 roles and 4 users when logged in as CASEM, but when logged in as a DBA, I can only see four roles and no users. Either this has to do with whether my username has "with admin option" or perhaps you are using ALL_% tables instead of the DBA_% tables. Is this a "bug" or a "feature"? Shouldn't I, as a DBA, be able to see all the grants and roles on any object in any schema?
thanks,
pat holmes

 

[Marco Kalter]

Maybe you need to enable the "Use DBA views if available" option (Tools > Preferences > Oracle / Options).

 

[Patrick Holmes]

That fixed it! It didn't occur to me that would even be an option. I just assumed that would be how it worked.

thanks!
pat