DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: How to change account_status in dba_users

Threaded View

  1. #2
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    Code:
    SQL> select account_status from dba_users where username='THOMAS';
    
    ACCOUNT_STATUS
    --------------------------------
    OPEN
    SQL> alter user thomas account lock;
    
    User altered.
    
    SQL> select account_status from dba_users where username='THOMAS';
    
    ACCOUNT_STATUS
    --------------------------------
    LOCKED
    
    SQL> alter user thomas account unlock;
    
    User altered.
    
    SQL> select account_status from dba_users where username='THOMAS';
    
    ACCOUNT_STATUS
    --------------------------------
    OPEN
    SQL> alter user thomas password expire;
    
    User altered.
    
    SQL> select account_status from dba_users where username='THOMAS';
    
    ACCOUNT_STATUS
    --------------------------------
    EXPIRED
    SQL> alter user thomas identified by thomas;
    
    User altered.
    
    SQL> select account_status from dba_users where username='THOMAS';
    
    ACCOUNT_STATUS
    --------------------------------
    OPEN
    Otherwise. no way...
    Last edited by Thomasps; 09-01-2006 at 06:46 AM.
    Thomas Saviour([email protected])
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width