Profile management

SQL> create profile tinku_profile limit
    failed_login_attempts 3
    password_lock_time unlimited
    password_life_time 20
    password_reuse_time 10
    password_verify_function verify_function
    password_grace_time 3;

Profile created.



SQL> alter profile default limit
     password_life_time 60
     password_grace_time 10
     password_reuse_time 1800
     password_reuse_max unlimited
     failed_login_attempts 3
     password_lock_time 1/1440
     password_verify_function verify_function;

Profile altered.



SQL> create profile deve_profile limit
    sessions_per_user 2
    cpu_per_session 10000
    idle_time 60
    connect_time 480;


==========================================================================================
                     GIVE PROFILE TO USERS
=======================================================================================


SQL> create user tinku identified by ku23$s
     default tablespace system
     temporary tablespace temp
     quota 15m on system
     quota 10m on temp
     profile tinku_profile;

User created.

SQL> grant connect,resource to tinku;

Grant succeeded.

SQL> conn tinku/ku23$s
Connected.
SQL>