TOAD

From: Ehresmann, David <David.Ehresmann_at_ps.net>
Date: Wed, 05 Feb 2003 07:09:14 -0800
Message-ID: <F001.0054443B.20030205070914@fatcity.com>

List,

I have a developer that I want to grant access to change another schema owner's packages in TOAD. I have granted connect, resource, and roles which incorporate DML on the tables and execute on the packages. When he goes into TOAD he can see the package spec but not the package body. How do I set up his privs to allow him to make changes to another's package bodies thru TOAD?

thanks,

David Ehresmann

--

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

Author: Ehresmann, David
  INET: David.Ehresmann_at_ps.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

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). Received on Wed Feb 05 2003 - 09:09:14 CST