Showing posts with label switch user. Show all posts
Showing posts with label switch user. Show all posts

Saturday, June 21, 2008

switch from sysdba to another user without password

SQL> CONNECT / as sysdba
Connected.

SQL> SELECT password FROM dba_users WHERE username='SCOTT';
PASSWORD
--------------- ---------------
F894844C34402B67

in 11g, the password won't display anymore, instead, use this:

SQL> select name,password from sys.user$ where name='SCOTT';
SQL> ALTER USER scott IDENTIFIED BY anything;
User altered.

SQL> CONNECT scott/anything
Connected.

OK, we're in. Let's quickly change the password back before anybody notices.

SQL> ALTER USER scott IDENTIFIED BY VALUES 'F894844C34402B67';
User altered.