Find table level privileges
635106Oct 14 2008 — edited Oct 15 2008For table t1 in schema user1
If I login as sysdba, do
select * from dba_tab_privs
where table_name='t1';
to check any privileges (e.g. select, delete) set up for table table t1 in schema user 1, in this case it return 0 row in the dba_tab_privs. Is there any other ways to check or that is the correct answer I got which means there is no privilege set up for table t1.
Edited by: user56753443 on Oct 14, 2008 5:41 PM