Hi,
I changed the account status of user sys to expired through oem , Now how to change it back again to the previous status.
Thanks
oracle :9.2.0.7
os :aix 5.2
Printable View
Hi,
I changed the account status of user sys to expired through oem , Now how to change it back again to the previous status.
Thanks
oracle :9.2.0.7
os :aix 5.2
Can you log in as system?
Login as any other user with DBA role.
And ask yourself why you did it!
Quote:
Originally Posted by SANJAY_G
S I can able to login as sys and system too.
aix> sqlplus "/ as sysdba"
logs me into db
aix>i can login as system too
but the aacount_status in dba_users shows me for sys as expired so how to change the status back to open for SYS
Thanks
change sys's password, (even if you keep same password) that will reset account_status to open
"expired" status seems to have no meaning for sys - makes total sense (you'd never want sys to expire)
Exactly. What tomcat said.
Code:SQL> select username, account_status from dba_users where username = 'SYS';
USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
SYS OPEN
SQL> alter user sys password expire;
User altered.
SQL> select username, account_status from dba_users where username = 'SYS';
USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
SYS EXPIRED
SQL> alter user sys identified by newpass;
User altered.
SQL> select username, account_status from dba_users where username = 'SYS';
USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
SYS OPEN