ALTER user COSWIN_SUPERVISOR account unlock ;
ALTER user coswin_supervisor IDENTIFIED BY supervisor ;
ALTER profile COSWIN_PROFILE LIMIT failed_login_attempts UNLIMITED
password_life_time UNLIMITED password_reuse_max UNLIMITED
password_grace_time UNLIMITED password_verify_function NULL ;
ALTER profile DEFAULT LIMIT failed_login_attempts UNLIMITED
password_life_time UNLIMITED password_reuse_max UNLIMITED
password_grace_time UNLIMITED password_verify_function NULL ;
Utilisateur modifiÚ.
SQL> ALTER profile COSWIN_PROFILE LIMIT failed_login_attempts UNLIMITED
2 password_life_time UNLIMITED password_reuse_max UNLIMITED
3 password_grace_time UNLIMITED password_verify_function NULL ;
Profil modifiÚ.
SQL> ALTER profile DEFAULT LIMIT failed_login_attempts UNLIMITED
2 password_life_time UNLIMITED password_reuse_max UNLIMITED
3 password_grace_time UNLIMITED password_verify_function NULL ;
Profil modifiÚ.
ALTER user COSWIN_SUPERVISOR account unlock ;
ALTER user coswin_supervisor IDENTIFIED BY supervisor ;
ALTER profile COSWIN_PROFILE LIMIT failed_login_attempts UNLIMITED
password_life_time UNLIMITED password_reuse_max UNLIMITED
password_grace_time UNLIMITED password_verify_function NULL ;
ALTER profile DEFAULT LIMIT failed_login_attempts UNLIMITED
password_life_time UNLIMITED password_reuse_max UNLIMITED
password_grace_time UNLIMITED password_verify_function NULL ;