CREATE PROFILE

Create a user profile

Syntax:

   CREATE PROFILE profile_name LIMIT limit(s) range

KEY
   limit  =  SESSIONS_PER_USER
             CPU_PER_SESSION
             CPU_PER_CALL
             CONNECT_TIME
             IDLE_TIME
             LOGICAL_READS_PER_SESSION
             LOGICAL_READS_PER_CALL
             COMPOSITE_LIMIT
             PRIVATE_SGA

   range  =  UNLIMITED | DEFAULT | integer

for PRIVATE_SGA specify K or M
e.g.
CREATE PROFILE MyProfile LIMIT PRIVATE_SGA 50 K

New with Oracle 8 are password related profile limits…

Syntax:

   CREATE PROFILE profile_name LIMIT pw_limit(s) range

KEY
  pw_limit = PASSWORD_LIFE_TIME
             PASSWORD_GRACE_TIME
             PASSWORD_REUSE_TIME
             PASSWORD_REUSE_MAX
             FAILED_LOGIN_ATTEMPTS
             PASSWORD_LOCK_TIME

   range  =  UNLIMITED | DEFAULT | expression

Syntax to customise password verification:

   CREATE PROFILE profile_name LIMIT PASSWORD_VERIFY_FUNCTION {plsql_function | NULL | DEFAULT}

Definitions
   CONNECT_TIME - Max. time user can stay connected 
   IDLE_TIME    - Max. time user can stay connected & idle
   PRIVATE_SGA  - Session space in the shared pool - K or M (bytes)
   COMPOSITE_LIMIT - A weighted sum of CPU_PER_SESSION, CONNECT_TIME, LOGICAL_READS_PER_SESSION, and PRIVATE_SGA. 
   PASSWORD_LIFE_TIME  - Expire password after X no of days
   PASSWORD_GRACE_TIME - Lock account X days after LIFE_TIME expires.
   PASSWORD_REUSE_TIME - Min. no. days before the same pw can be reused
   PASSWORD_REUSE_MAX  - Min. no. of number of pw changes before the current password can be reused
   FAILED_LOGIN_ATTEMPS - Max no. of incorrect logins before account is locked
   PASSWORD_LOCK_TIME  - Max. no. of days an account will be locked

DEFAULT refers to values set in the DEFAULT user profile.

"There are people who have money and people who are rich" ~ Coco Chanel

Related Oracle Commands:

PROFILE - ALTER PROFILE
PROFILE - DROP PROFILE
ROLE - CREATE ROLE