Explain how to lock and unlock a user account in Oracle

<<Previous  Next>>

Oracle - Explain how to lock and unlock a user account in Oracle - April 10, 2009 at 11:00 AM

Explain how to lock and unlock a user account in Oracle.  

SQL> ALTER USER user_name ACCOUNT LOCK;

SQL> ALTER USER user_name ACCOUNT UNLOCK;

Also read

Difference between locks, latches, enqueues and semaphores

Latches are used to protect Oracle data structures to be modified or run by more than one process. They are more restrictive than locks. Locking has a similar concept............... 

Oracle memory area

Software area code: - It is a protected location that is used to store oracle code that is supposed to be run. The location is different from users' programs. The software area code is read only and can be shared or nonshared...............

What is locking, advantages of locking and types of locking in oracle?

Locking protect table when several users are accessing the same table. Locking is a concurrency control technique in oracle. It helps in data integrity while allowing maximum..........

What are transaction isolation levels supported by Oracle?

READ COMMITTED: If row locks are obtained by a certain transaction, then any other transaction that contains DML needs to wait until the row locks have been released by that particular transaction..............

<<Previous  Next>>

Write your comment - Share Knowledge and Experience