OraFAQ Forum: Server Administration » How to see Schema user password in text

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)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to see Schema user password in text [message #567392]

Mon, 01 October 2012 01:25

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

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

Michel Cadot
Messages: 68757
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

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 02 10:19:09 CDT 2025