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 user;
USER is "NIRMAL"
[EMAIL PROTECTED]> grant execute on my_pack to scott;
Grant succeeded.
[EMAIL PROTECTED]> connect scott/tiger
Connected.
[EMAIL PROTECTED]> select * from user_tab_privs
2 where owner='NIRMAL' and table_name='MY_PACK';
GRANTEE OWNER TABLE_NAME
------------------------------ ------------------------------ ------------------------------
GRANTOR PRIVILEGE GRA
------------------------------ ---------------------------------------- ---
SCOTT NIRMAL MY_PACK
NIRMAL EXECUTE NO
Rgds,
Nirmal.
-----Original Message-----
From: SUNILSHIVAPPA [SMTP:[EMAIL PROTECTED]]
Sent: Monday, October 01, 2001 12:25 PM
To: Multiple recipients of list ORACLE-L
Subject: privileges on packages
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) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
