Home » RDBMS Server » Server Administration » How to see Schema user password in text (Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit)
How to see Schema user password in text [message #567392] Mon, 01 October 2012 01:25 Go to next message
AnilKampiri
Messages: 69
Registered: September 2012
Location: Chennai
Member

Dear All,

Good day!

Today i need to find one thing,I need to see all schema users password in a text.I am database admin,but it difficult to remember the password of all users created in single database,So we also dont want to change password of all time,Can you any one advice a table to view password in text.
Also we all know we can see using dba_users, but it was showing in hash value i need it in a text,Please advice.


Regards,
Anil


Re: How to see Schema user password in text [message #567397 is a reply to message #567392] Mon, 01 October 2012 01:55 Go to previous messageGo to next message
Littlefoot
Messages: 19331
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
As far as I can tell, there's no way to get information you are looking for.
Re: How to see Schema user password in text [message #567398 is a reply to message #567392] Mon, 01 October 2012 02:02 Go to previous messageGo to next message
Michel Cadot
Messages: 58616
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Database passwords are not stored in clear in Oracle, never.
In addition, you have not, never, to know user passwords.
It is user property.

What would you if your banker can know what you put in your safe?

Regards
Michel
Re: How to see Schema user password in text [message #567407 is a reply to message #567398] Mon, 01 October 2012 02:36 Go to previous message
AnilKampiri
Messages: 69
Registered: September 2012
Location: Chennai
Member

Dear All,

Thanks,For your valuable points for clearing my doubt.

Regards,
Anil


Previous Topic: user privileges changed misteriously
Next Topic: ORA-00059: maximum number of DB_FILES exceeded
Goto Forum:
  


Current Time: Wed Jul 30 01:12:30 CDT 2014

Total time taken to generate the page: 0.08779 seconds