Oracle unexpire password: differenze tra le versioni
Jump to navigation
Jump to search
(Creata pagina con '=Imposta per evitare la scadenza= <code> create profile nopasswdexpire_profile limit PASSWORD_LIFE_TIME unlimited FAILED_LOGIN_ATTEMPTS unlimited; begin for c1 in (select usern...') |
Nessun oggetto della modifica |
||
| Riga 28: | Riga 28: | ||
/ |
/ |
||
</code> |
</code> |
||
[[Categoria:Database]] |
|||
Versione delle 12:23, 20 ott 2014
Imposta per evitare la scadenza
create profile nopasswdexpire_profile limit PASSWORD_LIFE_TIME unlimited FAILED_LOGIN_ATTEMPTS unlimited;
begin
for c1 in (select username from dba_users where profile='DEFAULT')
loop
begin
execute immediate 'alter user ' || c1.username || ' profile nopasswdexpire_profile';
exception
when others then
null;
end;
end loop;
end;
/
Password Unexpire
begin
for c1 in (select t1.username u,t2.password p,t2.spare4 s from dba_users t1, sys.user$ t2 where t2.name=t1.username and t1.account_status in ('EXPIRED','EXPIRED(GRACE)') and t1.password_version='10G 11G')
loop
execute immediate 'alter user ' || c1.username || ' idenitified by values || c1.spare4 || ';' || c1.password ||
end loop;
end;
/