RE: Priv to view package bodies created by other users

From: Nicoll, Iain (Calanais) <iain.nicoll_at_calanais.com>
Date: Wed, 18 Apr 2001 09:13:05 -0700
Message-ID: <F001.002EBF10.20010418083149@fatcity.com>

Debbie,

You could try grant select on dba_source view.

Cheers

Iain Nicoll

-----Original Message-----
Sent: 18 April 2001 16:45
To: Multiple recipients of list ORACLE-L

I am a relatively new DBA and looking for advise. I have a request from our developers for the ability to view package body information which has been created by other users. We are currently using Oracle8i Enterprise Edition Release 8.1.6.1.0.

I have been advised that in order to view package bodies created by other users you need the "create any procedure" system privilege. To view type bodies created by other users you need the "create any type" system privilege.

Are there any object level privileges that would accomplish this request?

TIA for your help,

Debbie James

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Debbie James
INET: djames_at_usna.edu

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

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Nicoll, Iain (Calanais)
INET: iain.nicoll_at_calanais.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------