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-l