RE: Become User privilege

I normally would not even want to reorganize user tables. So I guess I never had a reason to complain about that. For the most part I deal only with the application accounts and I sure don't have 60 of those. I would then grant to roles and grant the roles to users. If joe blow developer needs a table in his own account they know how to create them or I tell them how (or point them to the proper manual). They do not need them tuned in that environment. They are not on my production system so its not affecting anything else. That is the way its worked on all enviroments I have been in. Now granted there could be someone out there that has 60 application accounts but if it should still be the dba touching the production accounts so consolidate the passwords.

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Jesse, Rich Sent: Tuesday, August 29, 2000 9:48 AM
To: Multiple recipients of list ORACLE-L 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).