| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: grants
Try this:
select * from DBA_TAB_PRIVS
where GRANTEE='X' and OWNER='Y' and
TABLE_NAME='<package_name>';
The privilege should have a value of 'EXECUTE'.
SQL> desc dba_tab_privs
Name Null? Type ----------------------------------- -------- ------------ GRANTEE NOT NULL VARCHAR2(30) OWNER NOT NULL VARCHAR2(30) TABLE_NAME NOT NULL VARCHAR2(30) GRANTOR NOT NULL VARCHAR2(30) PRIVILEGE NOT NULL VARCHAR2(40) GRANTABLE VARCHAR2(3)
HTP.
Gunawan Yuwono
Oracle DBA
Kansas City, MO
>--- Original Message ---
>From: gfaktor_at_ecal.com (Gregory Faktor)
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Date: 10/13/00 10:06:07 PM
>
>Hi All!
>It's there any way to find in DD if the user X have execute
privilege on
>package owned by user Y?
>Thanks.
>Greg.
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Gregory Faktor
> INET: gfaktor_at_ecal.com
>
>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: ListGuru_at_fatcity.com (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).
>
>
 |
 |