Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Third Party tool rant

Re: Third Party tool rant

From: Phil Singer <psinger1_at_chartermi.net>
Date: Fri, 5 Jan 2007 21:54:49 -0500
Message-ID: <45A06094.4030700@chartermi.net>


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
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Jan 05 2007 - 20:54:49 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US