15 Şubat 2012

Disabling db user password expiration

SELECT USERNAME, PROFILE, ACCOUNT_STATUS FROM DBA_USERS WHERE USERNAME LIKE 'TEST_%';
select resource_name,liMit from dba_profiles where profile='DEFAULT';
ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
alter user TEST_OIM identified by Oracle123;

Hiç yorum yok: