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?
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center