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;
**********************************************
对于一件事情,往往超过我们的想象,自信、坚持,勇往直前!
参与者:Rainbow Gu
地址:南都
***********************************************