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)
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
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,
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