User Management- Password file,Profile


$ 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;
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s