2014-08-02-1.sql

botang

select  * from dba_profiles p where p.profile='PROFILE1' and p.resource_type='PASSWORD';

select  * from dba_users u where u.username='HR';

alter user hr profile profile1;

select  * from dba_users u where u.username='HR';

alter profile profile1 limit password_reuse_max 1;