或者从系统视图中:select * from dba_tab_privs where table_name = 'TEST'
select grantee from dba_tab_privs where privilege='SELECT' and owner='&owner' and table_name='$table'; select grantee,column_name from dba_col_privs where privilege='SELECT' and owner='&owner' and table_name='$table';
select grantee from dba_tab_privs
where privilege='SELECT' and owner='&owner' and table_name='$table'; select grantee,column_name from dba_col_privs
where privilege='SELECT' and owner='&owner' and table_name='$table';
2 查询系统视图 楼上正解