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. Received on Tue Aug 29 2000 - 10:44:37 CDT