Re: dba_view to see privileges on procedures/packages/functinos

From: Ian Cary <cary_at_gatwick.geco-prakla.slb.com>
Date: 1997/10/17
Message-ID: <3447689E.C5325350@gatwick.geco-prakla.slb.com>#1/1

Michael E. Moores wrote:

> what view is there to obtain execute privileges on
> procedures and packages.
> all i can find is table privileges.

Believe it or not the view you require ia actually DBA_TAB_PRIVS !!!Packages and procedures can only have EXECUTE privilege, whereas tables can't so I guess oracle thought that it would be OK to use this view to contain both.
If you execute the query ;

select table_name,grantee,grantor,grantable from DBA_TAB_PRIVS
where privilege = 'EXECUTE';

it will tell who has execute privilege to what and whether they can pass on the privilege.

Hope this helps,

Ian Received on Fri Oct 17 1997 - 00:00:00 CDT