View original (French)

Le compte est verrouillé BD ORACLE

Solved
kd13 Posted messages 102 Status Member -  
 SAMIROU13 -
Hello,

I cannot connect to my Oracle database and the alert message indicates that my account is locked. I changed the password but to no avail, I am using Oracle 11g XE
please help me
Configuration: Windows 7 / Firefox 10.0.2

2 answers

  1.
    DROE Posted messages 148 Registration date   Status Member Last intervention   48
     
    Hello,

    You need to use the UNLOCK command.

    SQL> connect scott/tiger
    ERROR:
    ORA-28000: account locked

    How to unlock an Oracle USER.

    SQL>
    SQL> ALTER USER scott ACCOUNT UNLOCK;

    User altered.

    SQL> connect scott/tiger
    Connected.
    SQL>

    http://www.dba-ora.fr/article-oracle-user-quota-account-lock-unlock-expire-75481390.html
    --
    Experience is what everyone calls their mistakes.
    5