Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Oralce passwords

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

Expert Comment

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

Author Comment

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

Expert Comment

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

Author Comment

ID: 12748409
By SYS or SYSTEM user

Accepted Solution

lbireley04 earned 100 total points
ID: 12823352
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

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Phishing emails are a popular malware delivery vehicle for attack.  While there are many ways for an attacker to increase the chances of success for their phishing emails, one of the most effective methods involves spoofing the message to appear to …
With more and more companies allowing their employees to work remotely, it begs the question: What are some of the security risks involved with remote employees and what actions should we take to secure them?
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

564 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