RE: Grant access to EVERYTHING w/out granting DBA privs.

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:subscribe-oaugnet-dba_at_lists.ksinet.com
> 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: [Glenn.Travis_at_sas.com]
> To unsubscribe, forward this message to
> leave-oaugnet-dba-2379312T_at_lists.ksinet.com
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Glenn Travis
  INET: Glenn.Travis_at_sas.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).