RE: Become User privilege

I have about 150 users.

: (

Patrice Boivin
Systems Analyst (Oracle Certified DBA)

	-----Original Message-----
	From:	Jesse, Rich [SMTP:Rich.Jesse_at_qtiworld.com]
	Sent:	Tuesday, August 29, 2000 1:48 PM
	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