Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Third Party tool rant
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-lReceived on Fri Jan 05 2007 - 20:54:49 CST