Oracle Tips : How you know password hashkey in 11g

Oracle Tips : How you know password hashkey in 11g

In 9i 10g we can know password hashkey via dba_users

SQL> SELECT USERNAME,PASSWORD FROM DBA_USERS;

But in 11g the password hash is no longer accessible via dba_users
But we can show password hashkey via sys.user$

Connect to sys as sysdba
and use this query

SQL> SELECT NAME,PASSWORD FROM SYS.USER$;
Posted by The doG at 10:06 PM
Labels: How you know password hashkey in 11g, Oracle Knowhow Article, Oracle tips, password 11g, password hashkey 11g, user$

Source : How you know password hashkey in 11g

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *