Thanks to all who responded. This is what I eventually had to do (userid = glenn).
System privileges for GLENN... GRANTEE PRIVILEGE WITH ADMIN -------------------- ------------------------------ ---------- GLENN CREATE ANY PROCEDURE NO GLENN CREATE SESSION NO GLENN SELECT ANY TABLE NO Role privileges for GLENN... GRANTEE GRANTED_ROLE WITH ADMIN -------------------- ------------------------------ ---------- GLENN CONNECT NO GLENN SELECT_CATALOG_ROLE NO > -----Original Message----- > From: Glenn Travis > Sent: Wednesday, August 14, 2002 2:22 PM > To: OAUGnet-DBA > Subject: Grant access to EVERYTHING w/out granting DBA privs. > > > I want to create a user and grant it access to all other > users' objects, INCLUDING packages and procedures. I don't > want to give the user DBA privs. Is this possible? > > Basically, (for OracleApps shops), I want to give the id APPS > user power w/out giving the id the apps password. The userid > will need to bring up TOAD, or PL/SQL Developer and be able > to see any users objects and procedures. > > > > > > --- > Hosted by the Oracle Applications Users Group, which is > independent of Oracle Corp. > To subscribe, send a blank email to > mailto:[EMAIL PROTECTED] > Subscribers can search the Web Interface/Message Archive at > http://lists.ksinet.com/cgi-bin/lyris.pl?site=oaug > You are currently subscribed to oaugnet-dba as: [[EMAIL PROTECTED]] > To unsubscribe, forward this message to > [EMAIL PROTECTED] > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glenn Travis 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).
