Oracle查询表将权限赋给了哪些用户的SQL,以备查用。
select t.table_name as "表名",
t.grantee as "被授权的属组",
t.owner as "对象所在的属组",
t.grantee as "主动授权的属组",
t.privilege as "具体权限类型"
from dba_tab_privs t
where (t.grantee = upper('scott') or t.grantee = upper('sys'))
and T.privilege = 'SELECT'
and t.table_name in (upper('table_name1'), upper('table_name2'))
order by t.table_name;