Grants Missing from Object Browser as SYS

[Rich Hull]

When connected as SYS, and looking at another user's objects (say, BILL), when you expand an object such as a view to see the "Granted to Users" node, nothing appears in that node, even though such grants exist. When connected as BILL, and similarly expanding the object browser tree, the grants on that view do appear. I've noticed this for views, tables and packages. It may exists for other types of objects as well. I am almost certain that I have viewed these types of grants in the past (as SYS), so this seems like some type of regression. I'm using the latest (non-beta) version (13.0.5.1908, 64-bit).

 

[Marco Kalter]

Can you verify if the "Use DBA views if available" option is enabled on the Preferences > Oracle / Options page?

 

[Rich Hull]

It was not enabled. It is now, and the information is now coming through. Thanks! -R.