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: getting users passwords in plain text

Re: getting users passwords in plain text

From: Vincent verpoort <vincent.verpoort_at_gmail.com>
Date: Tue, 16 Oct 2007 17:08:26 +0200
Message-ID: <9b68098b0710160808v7dbe781fk34660599d5ea402d@mail.gmail.com>


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-l
Received on Tue Oct 16 2007 - 10:08:26 CDT

Original text of this message

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