skip to main | skip to sidebar

Oracle Tips-n-Tricks

A helpful list of useful Oracle SQL functions.

Tuesday, April 15, 2008

Unlock an Oracle user account

To unlock a user account within oracle, requires SYS or SYSTEM access to the SID.
alter user sample_user account unlock;
Posted by scspieker at 10:08 AM

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Blog Archive

  • ▼  2008 (13)
    • ▼  April (13)
      • Run SQL commands at login with SQL*Plus
      • Enabling SQL*Plus Help Utility
      • Using the default editor (Notepad or VI) for SQL C...
      • What are the basic SQL*Plus commands?
      • Shrink Oracle LOB columns
      • Display all TABLE Owning users with an Oracle SID
      • Find the Characterset Encoding for an Oracle SID
      • Display Oracle SID name using SQL
      • List existing user accounts within an Oracle SID
      • Find Oracle Server Version information using SQL
      • Unlock an Oracle user account
      • Sample Oracle Create User SQL Script
      • Oracle Create Tablespace Example