Oracle User Lock Unlock And Connect

Oracle User Lock-Unlock & Connect Permission

Topic Introduction: In this tutorial, we will show how to lock a user? How to unlock a user? and Require permission to connect users.

User Unlock

alter user hr account unlock;

User Password Change

alter user hr identified by hr123;

User Lock

alter user hr account lock;

User Unlock with Password Change

alter user hr identified by hr account unlock;

Connect Permission

grant connect, dba, resource to hr;

Toad connection Error Solution

grant select on sys.user$ to hr;