Why does a TOAD with DBA module show different grants than a TOAD without the DBA module? (32058)

User has two workstations running in  TOAD, but one has the DBA module and the other does not. When accessing the Grants  -tab for tables as user System, the two TOADs show different grants. Why?

A SQL Monitor session or Spool SQL shows the following queries being ran.

NON-DBA Module TOAD

Select PRIVILEGE, GRANTEE, GRANTABLE, GRANTOR
from sys.all_tab_privs
where table_name = 'EMPLOYEES'
and table_schema='JLIN'
order by grantee  

DBA MODULE TOAD

Select PRIVILEGE, GRANTEE, GRANTABLE, GRANTOR
from sys.dba_tab_privs
where table_name = 'EMPLOYEES'
and owner='JLIN'
order by grantee

if you look closely, one query pulls from the all_tab_privs table and one pulls from the dba_tab_privs table. Why?

Whether the option ""Check for access to DBA views" is enabled or not determines what grants are pulled up.

Depending on what you want to see, if DBA views then checking the DBA views option will show dba_tab_privs table. Otherwise TOAD will show all_tab_privs table.

To get to the DBA views option in TOAD, do the following.

1. Go to View | TOAD Options.
2. In the left panel, select Startup.
3. In the right panel, select or not "Check for access to DBA views."
4. Restart TOAD to make the option take into effect.