Unknown





(Oracle Database Tutorial - 07) - How To Give Profile a Specific User





******** How To Give Profile to New User************





when create a new user, have to give a profile , otherwise it use default profile..









Resource of profile:





Resource Parameter Sessions_per_user number of connect sessions to set the limit for user. 2. cpu_per_session Set time Limit for Cpu per session (1 Sec=100) 3. cpu_per_call Set time Limit for Cpu per call (1 Sec=100) 4. connect_time Set time limit for a session 5. idel_time Set idle time for in active uses 6. logical_read_per_session Permitted number of data block read in a session 7. logical_read_per_call Permitted number of data block read for a call to execute SQL statement 8. privet SGA Allocate the specific amount of (SGA) system global area









*********PROFILE COMPOSITE LIMIT:***********





cpu_per_session, connect_time, logical_read_per_session, privet SGA called PROFILE COMPOSITE LIMIT .

Password parameters:





Password Parameter FAILED_LOGIN_ATTEMPTS Set number of chance login then account will be lock PASSWORD_LIFE_TIME Set password Validate Time Duration PASSWORD_GRACE_TIME Set remainig date & will display the remaining date e.g: 7, 6, 5 ...days left] PASSWORD_REUSE_MAX how much use same password PASSWORD_REUSE_TIME Set password reuse time PASSWORD_LOCK_TIME Set time for wrong Password lock time PASSWORD_VERIFY_FUNCTION DEFAULT [ need a algorithom]









How to Create profile





SQL> CREATE PROFILE Shaikat_prof LIMIT

CPU_PER_SESSION 1000

CPU_PER_CALL 1000

CONNECT_TIME 30

IDLE_TIME 15

SESSIONS_PER_USER 2

LOGICAL_READS_PER_SESSION 1000

LOGICAL_READS_PER_CALL DEFAULT

PRIVATE_SGA 256K

COMPOSITE_LIMIT 1000000

PASSWORD_LIFE_TIME 10

PASSWORD_GRACE_TIME 1

PASSWORD_REUSE_MAX 3

PASSWORD_REUSE_TIME 5

PASSWORD_LOCK_TIME 2

FAILED_LOGIN_ATTEMPTS 2

PASSWORD_VERIFY_FUNCTION DEFAULT;





























































Now Check Profile Created As a Name of SHAIKAT_PROF :





SQL> select profile from dba_profiles where profile='SHAIKAT_PROF';













***Now Check User Name "SHAIKATUSTC09" profile name:





SQL> select username,profile from dba_users where username='SHAIKATUSTC09';

















Now we will assign Profile to a user









SQL> alter user SHAIKATUSTC09 profile Shaikat_Prof;













Now Check The Given All Profile resource & Password Parameter are correctly created or Not





SQL> select username,profile from dba_users where username='SHAIKATUSTC09';





Profile Resource_name Resource_Type Limit SHAIKAT_PROF COMPOSITE_LIMIT KERNEL 1000000 SHAIKAT_PROF SESSIONS_PER_USER KERNEL 2 SHAIKAT_PROF CPU_PER_SESSION KERNEL 1000 SHAIKAT_PROF CPU_PER_CALL KERNEL 1000 SHAIKAT_PROF LOGICAL_READS_PER_SESSION KERNEL 1000 SHAIKAT_PROF LOGICAL_READS_PER_CALL KERNEL DEFAULT SHAIKAT_PROF IDLE_TIME KERNEL 15 SHAIKAT_PROF CONNECT_TIME KERNEL 30 SHAIKAT_PROF PRIVATE_SGA KERNEL 262144 SHAIKAT_PROF FAILED_LOGIN_ATTEMPTS PASSWORD 2 SHAIKAT_PROF PASSWORD_LIFE_TIME PASSWORD 10 SHAIKAT_PROF PASSWORD_REUSE_TIME PASSWORD 5 SHAIKAT_PROF PASSWORD_REUSE_MAX PASSWORD 3 SHAIKAT_PROF PASSWORD_VERIFY_FUNCTION PASSWORD DEFAULT SHAIKAT_PROF PASSWORD_LOCK_TIME PASSWORD 2 SHAIKAT_PROF PASSWORD_GRACE_TIME PASSWORD 1









NOTE: Next Class 8,We will Discuss How to Give Privilege to User





*************Thank You*************