December 2002
Intermediate to advanced
928 pages
85h 29m
English
CREATE/ALTER/DROP PROFILE
CREATE Syntax:
CREATE PROFILEprofile_nameLIMIT [SESSIONS_PER_USERinteger| UNLIMITED | DEFAULT] [CPU_PER_SESSIONinteger| UNLIMITED | DEFAULT] [CPU_PER_CALLinteger| UNLIMITED | DEFAULT] [CONNECT_TIMEinteger| UNLIMITED | DEFAULT] [IDLE_TIMEinteger| UNLIMITED | DEFAULT] [LOGICAL_READS_PER_SESSIONinteger| UNLIMITED | DEFAULT] [LOGICAL_READS_PER_CALLinteger| UNLIMITED | DEFAULT] [PRIVATE_SGA {integer[K | M] | UNLIMITED | DEFAULT}] [COMPOSITE_LIMIT {integer| UNLIMITED | DEFAULT}] [FAILED_LOGIN_ATTEMPTSexpr| UNLIMITED | DEFAULT] [PASSWORD_LIFE_TIMEexpr| UNLIMITED | DEFAULT] [PASSWORD_REUSE_TIMEexpr| UNLIMITED | DEFAULT] [PASSWORD_REUSE_MAXexpr| UNLIMITED | DEFAULT] [PASSWORD_LOCK_TIMEexpr| UNLIMITED | DEFAULT] [PASSWORD_GRACE_TIMEexpr| UNLIMITED | DEFAULT] [PASSWORD_VERIFY_FUNCTIONfunction| NULL | DEFAULT]
ALTER Syntax:
ALTER PROFILEprofile_nameLIMIT [SESSIONS_PER_USERinteger| UNLIMITED | DEFAULT] [CPU_PER_SESSIONinteger| UNLIMITED | DEFAULT] [CPU_PER_CALLinteger| UNLIMITED | DEFAULT] [CONNECT_TIMEinteger| UNLIMITED | DEFAULT] [IDLE_TIMEinteger| UNLIMITED | DEFAULT] [LOGICAL_READS_PER_SESSIONinteger| UNLIMITED | DEFAULT] [LOGICAL_READS_PER_CALLinteger| UNLIMITED | DEFAULT] [PRIVATE_SGAinteger[K | M] | UNLIMITED | DEFAULT] [COMPOSITE_LIMITinteger| UNLIMITED | DEFAULT] [FAILED_LOGIN_ATTEMPTSexpr| UNLIMITED | DEFAULT] [PASSWORD_LIFE_TIMEexpr| UNLIMITED | DEFAULT] [PASSWORD_REUSE_TIMEexpr| UNLIMITED ...