privileges on packages

2001-10-01 Thread SUNILSHIVAPPA
hi, HOW to find out the whether a particular user has a execute permission on package or not. Regards, sunil s. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SUNILSHIVAPPA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858)

Re: privileges on packages

2001-10-01 Thread Dennis M. Heisler
It's in DBA_TAB_PRIVS. Dennis SUNILSHIVAPPA wrote: hi, HOW to find out the whether a particular user has a execute permission on package or not. Regards, sunil s. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dennis M. Heisler INET: [EMAIL

RE: privileges on packages

2001-10-01 Thread Walthour, Jon (GEAE, Compaq)
Check out DBA_TAB_PRIVS and look for the EXECUTE privilege. Jon Walthour -Original Message- Sent: Monday, October 01, 2001 5:25 AM To: Multiple recipients of list ORACLE-L hi, HOW to find out the whether a particular user has a execute permission on package or not. Regards,

RE: privileges on packages

2001-10-01 Thread Nirmal Kumar Muthu Kumaran
Title: RE: privileges on packages USER_TAB_PRIVS. Here is an example: [EMAIL PROTECTED] create or replace package my_pack is 2 type abc_t is table of number index by binary_integer; 3 p_abc abc_t; 4 p_un varchar2(20); 5 end my_pack; 6 / Package created. [EMAIL PROTECTED] show