User Management-II (Password file,Profile

                                                User Management -II

                                      Creating Password file for instance

$ orapwd file=orapw<sid>  password=<password> force=y entries=<n>

Eg:

 $ orapwd file=orawprod password=fm123 force=y entries=10

Assigning sysdba and sysoper privilages to user 

Sql> grant sysdba to fm;

Sql>grant sysoper to fm1;

$ sqlplus fm/fm  as sysdba

Sql>show user

       SYS

$ sqlplus fm1/fm1 as sysoper

Sql>show user

       PUBLIC

Profiles 

Creating profile

Sql> create profile prof1 limit

          Failed_login_attempts 3   (no of attempts)

          Password_lock_time 1   (no of days)   1/24  (for 1 hour)

          Password_life_time 7   (no of days)

          Session_per_user 5          (no of total sessions)

          Idle_time 1            (in minutes)

          Connect_time 600;  (10 hours)

Assigning profile

Sql>  create user fm idenfied by fm Profile prof1;

Sql> alter user fm profile prof1;

·       To enforce kernel/resource parameters the following parameter must be set

Sql> alter system set resource_limit=true scope=both;

Applying password restriction in profile:

Sql> @$ORACLE_HOME/rdbms/admin/utlpwdmg.sql;

Sql> alter profile prof1 limit

          Password_verify_function verify_function;

Sql> alter profile prof1 limit

          Password_verify_function null;