Re: Become User privilege

I consider myself the database administrator, not the data administrator.

It's not all that hard to write dynamic sql to grant access to a schema object to a user.

• Original Message ----- From: Jesse, Rich <Rich.Jesse_at_qtiworld.com> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Tuesday, August 29, 2000 11:48 AM Subject: RE: Become User privilege

> That'll work fine and dandy until you try and GRANT privs on those objects
> to other users.
>
> <soapbox on>
>
> 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>
>
> <soapbox off>
>
> 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 - 13:51:32 CDT