Oralce passwords

Posted on 2004-11-26
Last Modified: 2010-04-11
Hi experts
How can i find the other use passwords in oracle 9i?
Question by:rooholamini
    LVL 51

    Expert Comment

    "find" password?
    do you mean "how to ask" other users?

    Author Comment

    consider this:
    "I have DBA role and i want to know the other user passwords".
    LVL 51

    Expert Comment

    what do you mean by "DBA role"? administrator?
    I'd simply ask the user

    Author Comment

    By SYS or SYSTEM user

    Accepted Solution

    Here's what I have used as a DBA when I need to log on as someone who isn't available (or give access to someone else) for whatever legitimate reason - on vacation, sick etc.. and someone needs to do something in that schema.

    Note:  Oracle's security model is such that you cannot get the password but the hash value.  Save this so you can set the user's password back after you are done - so you won't have to be bothered when the person gets back.

    Getting the hash value:
    SELECT username, password
    FROM dba_users
    WHERE username = 'FRED';

    As DBA you can change the password to a new one:
    ALTER USER fred IDENTIFIED BY newpassword;

    Setting the user's password back:
    ALTER USER username IDENTIFIED BY VALUES 'paste in the value you saved';

    As for your 'DBA role' question.  Oracle provides for the creation of 'Roles' these are groups of access priviledges that let you either perform specific functions such as 'CREATE TABLE' or access specific objects in another schema.  The DBA role is a default one created in the installation which allows you to do most things SYS or SYSTEM can do - but not all.

    Before you try any of this at work or home, I would suggest you invest in a DBA course from Oracle Education and/or get some books 'Oracle DBA 101' is a good place to start.
    Good luck and be safe :->

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Join & Write a Comment

    Ransomware continues to be a growing problem for both personal and business users alike and Antivirus companies are still struggling to find a reliable way to protect you from this dangerous threat.
    This story has been written with permission from the scammed victim, a valued client of mine – identity protected by request.
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…
    This video discusses moving either the default database or any database to a new volume.

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now