Harsh’s Tech blog

Harsh back with Blog

»

How to Lock/Unlock user Account in Oracle

Posted by harshanurodh on April 26, 2009

# Log in oracle server

# sqlplus /as sysdba

# ALTER USER username ACCOUNT LOCK;

# ALTER USER username ACCOUNT UNLOCK;

This entry was posted on April 26, 2009 at 10:08 am and is filed under Oracle. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

One Response to “How to Lock/Unlock user Account in Oracle”

  1. Bijay said

    April 27, 2009 at 8:19 am

    Thanks,
    all are working fine.

    Reply

Leave a Reply

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <pre> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

»