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.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy