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

Report message to a moderator

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: 21823
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.

Report message to a moderator

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: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
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

Report message to a moderator

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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Feb 23 12:36:51 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.