Re: Third Party tool rant

  • From: Phil Singer <psinger1@xxxxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Sat, 06 Jan 2007 21:53:08 -0500

Wolfgang Breitling wrote:
Why not grant the toad users SELECT_CATALOG_ROLE. Probably not ideal, but a heck of a lot better than DBA.


Excellent idea (will break a few things in TOAD, but you will want those things broken anyway). But, just to be complete, first create a role that looks just like SELECT_CATALOG_ROLE, but has permissions to a variation of DBA_USERS which doesn't have the hashed password in it.

[I know this is obvious to most on this list, but it may not be for a few lurkers].



--
Phil Singer                         |   psinger1 at chartermi dot net
PhD, OCP, and All Around Good Guy   |   Do the Obvious to Reply
--
//www.freelists.org/webpage/oracle-l


Other related posts: