Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: getting users passwords in plain text
i thought of doing a insert into mytable values (username,password);
in the $ORACLE_HOME/rdbms/admin/utlpwdmg.sql
<http://download-uk.oracle.com/docs/cd/B10501_01/server.920/a96536/ch53.htm#1005955>
but i don't wanne edit or write anything more looking for a scritp
that converts the hase to plain text
On 10/16/07, Sweetser, Joe <JSweetser_at_icat.com> wrote:
>
> Not exactly sure what you want to do, but you might google for the
> undocumented "alter user XXX identified by values..." command. It will let
> you set the passwords back to what they were without knowing them.
>
> hth,
> -joe
>
> ------------------------------
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Vincent verpoort
> *Sent:* Tuesday, October 16, 2007 7:14 AM
> *To:* Oracle-L Freelists
> *Subject:* getting users passwords in plain text
>
> Hi Experts,
>
> I have a question that's a bit unethical.
>
> For a company i'm working for i need to find out what the passwords are of
> oracle users. As changing them means a lot of work for allot of poeple.
>
> Is there anyway i can clear text the password from dba database, i have
> sysdba and all privs.
>
> any points would be nice also i want to put this into script so if anyone
> has something ?
>
> --
> Vincent Verpoort
>
> ,.-~`"'~-.,_,.-~`"'~-.,_,.-~`"'~-.,_,.-~`"'~-.,_,.-~`"'~-.,_
> Communiceren is begrepen worden
> ^*<-._,.->*^*<-._,.->*^*<-._,.->*^*<-._,.->*^*<-._,.->*^*<-.
>
>
-- Vincent Verpoort ,.-~`"'~-.,_,.-~`"'~-.,_,.-~`"'~-.,_,.-~`"'~-.,_,.-~`"'~-.,_ Communiceren is begrepen worden ^*<-._,.->*^*<-._,.->*^*<-._,.->*^*<-._,.->*^*<-._,.->*^*<-. -- http://www.freelists.org/webpage/oracle-lReceived on Tue Oct 16 2007 - 10:08:26 CDT
![]() |
![]() |