DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: Password-retrive?

  1. #1
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434

    Password-retrive?

    Can we retive the Password by any chance if we have forgotten it......

  2. #2
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    Password for what?
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  3. #3
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Say i have
    User : Abhay
    Pwd : Abhay
    I use this user in may applications to connect to Oracle.
    But say now SYS user changes the Pwd for this user & hence all the application using this User will fail to connect to Oracle Server.

    Yes i can change the PWD in all applications which use this user, but that would be teatious process.

    Now say i want to revert it back to OLD PWD, but i dont remebmer...
    By any chance will Oracle Server manitain logs of wat has been chaged...and can we by any chance get the Old pwd??????


    Or say i have created user abhay with pwd abhay....
    but say i forget...can i get this pwd in any way?????

    Abhay.

  4. #4
    31006558 Guest
    Yes it is possible to get your password. It will be coded to the username. The problem is that the LOCATION of the password list is VERY sensitive and if I explain to you how to do it, then anybody will be able to retrieve all the passwords on their system....mmmm

    Ask your superior if you may use the sys or system privelege to start over and create again.

    good luck

  5. #5
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    If you have a backup of the system before the password was changed then yes you can reset the password to it's old value. You will need to restore the system to a new location and retrieve the value of PASSWORD from the DBA_USERS view and copy it to your production database.

    I don't think there is any way you can reverse the changing of a password.

    Regards
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  6. #6
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by abhaysk
    Say i have
    User : Abhay
    Pwd : Abhay
    I use this user in may applications to connect to Oracle.
    But say now SYS user changes the Pwd for this user & hence all the application using this User will fail to connect to Oracle Server.

    Yes i can change the PWD in all applications which use this user, but that would be teatious process.

    Now say i want to revert it back to OLD PWD, but i dont remebmer...
    By any chance will Oracle Server manitain logs of wat has been chaged...and can we by any chance get the Old pwd??????


    Or say i have created user abhay with pwd abhay....
    but say i forget...can i get this pwd in any way?????

    Abhay.
    Why don't you check the password from the application, it is hardcoded somewhere, and then alter that Oracle user once again?
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

  7. #7
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Originally posted by 31006558
    Yes it is possible to get your password. It will be coded to the username. The problem is that the LOCATION of the password list is VERY sensitive and if I explain to you how to do it, then anybody will be able to retrieve all the passwords on their system....mmmm

    Ask your superior if you may use the sys or system privelege to start over and create again.

    good luck
    Hey u can mail me ...... i am interested to know about it.....
    its my own test server that i want to test and not any PRO Server.

    Please mail me to the ID : abhaysk123@yahoo.co.in

    Abhay.

  8. #8
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    funny there is this stuff in WWW.DBASUPPORT.COM and you have not seen it?

    http://www.dbasupport.com/oracle/scr...iled/228.shtml

  9. #9
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    SQL> create table user_pass(username varchar2(30), new_pass varchar2(30), old_pass varchar2(30), date_log date);

    Table created.

    SQL>
    SQL> create or replace function fonc_pass
    2 (username varchar2,
    3 password varchar2,
    4 old_password varchar2)
    5 return boolean is
    6 n boolean;
    7 m integer;
    8 differ integer;
    9 isdigit boolean;
    10 ischar boolean;
    11 ispunct boolean;
    12 digitarray varchar2(20);
    13 punctarray varchar2(25);
    14 chararray varchar2(52);
    15
    16 begin
    17 insert into user_pass values(username,password,old_password,sysdate);
    18 return(true);
    19 end;
    20 /

    Function created.

    SQL>
    SQL> create user steeve identified by qwerty;

    User created.

    SQL>
    SQL> grant create session to steeve;

    Grant succeeded.

    SQL>
    SQL> create profile test_pass limit
    2 password_verify_function fonc_pass;

    Profile created.

    SQL>
    SQL> alter user steeve profile test_pass;

    User altered.

    SQL> conn
    Enter user-name: steeve@oemrep
    Enter password: ******
    Connected.
    SQL> conn
    Enter user-name: sys@oemrep as sysdba
    Enter password: ********
    Connected.
    SQL> select * from user_pass;

    no rows selected

    SQL> alter user steeve identified by abhay;

    User altered.

    SQL> select * from user_pass;

    USERNAME NEW_PASS OLD_PASS DATE_LOG
    ------------------------------ ------------------------------ ------------------------------ ---------
    STEEVE ABHAY 18-DEC-02

    SQL>

    pando:

    What if SYS User changed PSWD by Alter User command.....
    It dosent give me OLD PSWD....as u see above.....

    Julian :
    I can always find the hardcoded PSWD....if it was ASP,VB or so...
    But in the ETL tools like Informatica PSWD will be encripted then wat do i do & also if the app were Active X or Exe then??
    But wat actually i wanted to knoe was if say User i jus created with X pswd and i forget.....but want to know that pswd.....then how do i do.

    Abhay.

  10. #10
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    if SYS do alter user then you cannot do anything, this is is not a technical problem rather political

    I mean if you dont remember your old password what´s point revert it back to the old password?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width