— obj_privs.sql
— mdw 09/11/01
— Hard tho it is to believe, I had no script to show privs on an obj
— so wrote one now.
col grantee form a12 word wrap
col owner form a12 word wrap
col table_name form a22 word wrap
col grantor form a12 word wrap
col privilege form a12 word wrap
col grantable form a3
spool obj_grnats.lst
select grantee
,owner
,table_name
,grantor
,privilege
,grantable
from dba_tab_privs
where table_name like upper(nvl(‘&obj_name’,’WHOOPS’))||’%’
and  owner like upper(‘&obj_own’)||’%’
order by table_name,owner
/
spool off
clear colu