Oracle中询表的权限被授予给了哪些用户

数据库  /  管理员 发布于 2年前   409

        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;