2012年
-
编辑 删除
Reset user password in 11g
Reset user's password in 11g[@more@]SQL> create user lyon identified by test; User created. SQL> select USERNAME,PASSWORD,ACCOUNT_STATUS ,PROFILE from dba_users where USERNAME='LYON'; USERNAME PASSWORD ------------------------------ ------------------------------ ACCOUNT_STATUS PROFILE -------------------------------- ------------------------------ LYON OPEN DEFAULT SQL> select password,spare4 from user$ where name='AMIT'; no rows selected SQL> select password,spare4 from user$ w
