Oracle查询（对象）权限

set linesize 300 pagesize 900 
col GRANTEE for a20 
col owner for a15 
col TABLE_NAME FOR A40 
col PRIVILEGE FOR A10 
select GRANTEE,OWNER,TABLE_NAME,PRIVILEGE from dba_tab_privs where TABLE_NAME =upper('&table') order by PRIVILEGE;

--------- dba_tab_privs

select * from dba_tab_privs where GRANTEE='&username';
select * from dba_tab_privs where GRANTEE='$username' and TABLE_NAME='$tablename';