RE: Become User privilege

From: <achoto_at_american.edu>
Date: Tue, 29 Aug 2000 13:21:51 -0400
Message-Id: <10603.115756@fatcity.com>

Right on!

Ana

                                                                                                                     
                    "Jesse, Rich"                                                                                    
                    <Rich.Jesse_at_qti        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>       
                    world.com>             cc:                                                                       
                    Sent by:               Subject:     RE: Become User privilege                                    
                    root_at_fatcity.co                                                                                  
                    m                                                                                                
                                                                                                                     
                                                                                                                     
                    08/29/00 12:48                                                                                   
                    PM                                                                                               
                    Please respond                                                                                   
                    to ORACLE-L

That'll work fine and dandy until you try and GRANT privs on those objects to other users.

No one has yet been able to satisfactorily explain to me, the "A" in "DBA", why I don't have full control of database security! I can create objects on
behalf of users, but I can't grant security on those objects to others??? So now I have to have a list of 60 different Oracle accounts and passwords that I need to use and maintain in order to reorg user tables. Why, why, WHY??? <fume, fume>

Rich Jesse                          System/Database Administrator
Rich.Jesse_at_qtiworld.com             QTI -- Sussex, WI USA

> -----Original Message-----
> From: Kimberly Smith [mailto:kimberly.smith_at_gmd.fujitsu.com]
> Sent: Tuesday, August 29, 2000 11:09
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Become User privilege
>
>
> You could actually do what you want to do without logging on as that
> user. One method is get a copy of Toad. I do most of my stuff signed
> in as the DBA including recompling the packages of other users. But
> if you truly want to do the whole schema user a dynamic script where
> you pick the owner and name from the dba_objects table. Simple and
> you never have to update a script when a new package is added.

This message has been scanned for viruses with Trend Micro's Interscan VirusWall.

--
Author: Jesse, Rich
  INET: Rich.Jesse_at_qtiworld.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).

Received on Tue Aug 29 2000 - 12:21:51 CDT