690 shaares
3 liens privés
3 liens privés
Supprimer l'expiration de password Oracle pour les bases de dev
SELECT PROFILE FROM dba_users WHERE username = 'SCOTT';
SELECT LIMIT FROM DBA_PROFILES WHERE PROFILE='DEFAULT' AND RESOURCE_NAME='PASSWORD_LIFE_TIME';
ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
SELECT ACCOUNT_STATUS FROM DBA_USERS WHERE USERNAME='SCOTT';
et aussi :
alter user <username> identified by <password>;