Database Administration (MOSC)

MOSC Banner

oracle password in version 11.2

edited Sep 8, 2012 6:02PM in Database Administration (MOSC) 4 commentsAnswered
Hello

I am looking at the password data for oracle IDs in a database that was just upgraded from 10.2.0.4 to 11.2.0.3 and here is what I see

SQL> select name, spare4 from user$ where name in ('TEST1','OUTLN');

NAME                           SPARE4
------------------------------ --------------------------------------------------
OUTLN
TEST1                          S:XXX

                              
SQL> select username, password , password_versions from dba_users where username in ('TEST1','OUTLN');

USERNAME                       PASSWORD                       PASSWORD
------------------------------ ------------------------------ --------
OUTLN                                                         10G
TEST1                                                         10G 11G


TEST1 is an ID that I have created after the upgrade. So the password value is stored in the spare4 column in user$ table. OUTLN is an ID that was creaed under v10 version so I expected to see the value in the password column of the dba_users table, but that column is empty.  Is that how it is supposed to look like or am I missing something? Would appreciate any thoughts

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center