Thursday, August 1, 2013

How to quickly unlock expired Oracle database users

This post is a self note on unlocking an expired oracle database user.

OS: window

1. Open command prompt, and execute the following command
sqlplus sys/[PASSWORD] @ [SID] as sysdba

2. View expired users with the following command
Select username, account_status from dba_users where account_status like 'EXPIRED';

3. Activate user with the following command
Alter user [USERNAME] identified by [PASSWORD];


Done!!

LinkWithin

Related Posts Plugin for WordPress, Blogger...