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
Related Views:
DBA_PROFILES
DBA_SYS_PRIVS USER_SYS_PRIVS ROLE_SYS_PRIVS
V$SESSION
V$SESSION_CONNECT_INFO
V$SESSTAT
V$SESS_IO