Home » SQL & PL/SQL » SQL & PL/SQL » regarding users information
regarding users information [message #23426] Fri, 06 December 2002 21:49 Go to next message
sha
Messages: 84
Registered: July 2002
Member
Hi,
In which table users and passwords are stored in oracle?
passwords in this table are stored in encrypted format or decrypted format?
regards,
shastri

Report message to a moderator

Re: regarding users information [message #23429 is a reply to message #23426] Sat, 07 December 2002 10:26 Go to previous messageGo to next message
Aarty
Messages: 4
Registered: November 2002
Junior Member
SQL> select username, user_id, password from dba_users;

Need dba privileges to view this.

Password is stored in encrypted format

Report message to a moderator

Re: regarding users information [message #23431 is a reply to message #23426] Sun, 08 December 2002 18:31 Go to previous messageGo to next message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
The passwords are not encrypted - they are hashed.

Report message to a moderator

Re: regarding users information [message #23437 is a reply to message #23426] Mon, 09 December 2002 10:45 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
You cannot decrypt Oracle passwords because they are not encypted. See:

http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:536222412604

Report message to a moderator

Previous Topic: Export tables from Stored procedure
Next Topic: Year in Roman Numerals
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu May 16 18:28:35 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.