Object browser and "Granted to users"

[denmarkdev]

How does PL/SQL Dev retrieve the roles under table->mytable->Granted to users?

How do I ensure that I see every role granted on a table (also if also granted to other users)?

 

[Marco Kalter]

It queries the sys.all_tab_privs view.

 

[denmarkdev]

Would it be a idea to query DBA_TAB_PRIVS when logged in as sys, so we see all grants on a object?

 

[Marco Kalter]

That will happen if you enable the "Use DBA views if available" option (Tools > Preferences > Oracle / Options).

 

[pgacv2]

Would it be a better idea to use the DBA views by default, and fall back to ALL_* only if they are not available? We recently went through a confusing few days trying to figure out why a user showed tables A/B/C in all_tab_privs but could actually view data from A/B/C/D/E/F/G. It turned out we needed to check dba_tab_privs instead.

I don't think it makes sense to query a less-privileged view by default, and have to explicitly check a box to be able to see it, regardless of whether the DBA view is available to me.

 

[IvanZ]

Yes, this option shoud be checked by default.