Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

will user with this profile gets locked after 90 days?

marlborocatNov 2 2012 — edited Nov 3 2012
will user with this USERS_PROFILE profile gets locked automatically after 90 days?

in another word, is there any way oracle will lock user automatically after certain dormant days based on the profile?




PROFILE RESOURCE_NAME RESOURCE LIMIT
------------------------------ -------------------------------- -------- ----------------------------------------
USERS_PROFILE COMPOSITE_LIMIT KERNEL DEFAULT
USERS_PROFILE SESSIONS_PER_USER KERNEL 15
USERS_PROFILE CPU_PER_SESSION KERNEL DEFAULT
USERS_PROFILE CPU_PER_CALL KERNEL DEFAULT
USERS_PROFILE LOGICAL_READS_PER_SESSION KERNEL DEFAULT
USERS_PROFILE LOGICAL_READS_PER_CALL KERNEL DEFAULT
USERS_PROFILE IDLE_TIME KERNEL 60
USERS_PROFILE CONNECT_TIME KERNEL DEFAULT
USERS_PROFILE PRIVATE_SGA KERNEL DEFAULT
USERS_PROFILE FAILED_LOGIN_ATTEMPTS PASSWORD 6
USERS_PROFILE PASSWORD_LIFE_TIME PASSWORD 90

PROFILE RESOURCE_NAME RESOURCE LIMIT
------------------------------ -------------------------------- -------- ----------------------------------------
USERS_PROFILE PASSWORD_REUSE_TIME PASSWORD 5000
USERS_PROFILE PASSWORD_REUSE_MAX PASSWORD UNLIMITED
USERS_PROFILE PASSWORD_VERIFY_FUNCTION PASSWORD VERIFY_PASSWD
USERS_PROFILE PASSWORD_LOCK_TIME PASSWORD UNLIMITED
USERS_PROFILE PASSWORD_GRACE_TIME PASSWORD DEFAULT
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 1 2012
Added on Nov 2 2012
16 comments
548 views