Collect common Oracle commands-manage password security and resources)

Common Oracle commands-manage 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 failed_login_attempts 3
SQL> password_life_time 60 password_grace_time 10;

5. Drop a profile
SQL> drop profile grace_5 [cascade];

6. Create a profile: resource limit
SQL> Create profile pai_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;