Oracle数据库命令速查手册- managing password security and resources

1.controlling account lock and password
sql> alter user juncky identified by oracle account unlock; 
2.user_provided password function 
sql> function_name(userid in varchar2(30),password in varchar2(30), 
old_password in varchar2(30)) return boolean 
3.create a profile : password setting 
sql> create profile grace_5 limit failed_login_attempts 3 
sql> password_lock_time unlimited password_life_time 30 
sql>password_reuse_time 30 password_verify_function verify_function 
sql> password_grace_time 5; 
4.altering a profile 
sql> alter profile default limit 
sql> failed_login_attempts 3 
sql> password_life_time 60; 
5.drop a profile 
sql> drop profile grace_5 [cascade]; 
6.create a profile : resource limit 
sql> create profile developer_prof limit sessions_per_user 2 
sql> cpu_per_session 10000 idle_time 60 connect_time 480; 
7. view => resource_cost : alter resource cost 
dba_Users,dba_profiles 
8. enable resource limits 
sql> alter system set resource_limit=true;