question

OraLearner avatar image
OraLearner asked

Automatic unlock option in oracle ?

Do we have any property for a user account in oracle, to be by default get unlocked if it is locked after a specific period of time?

This will avoid us to unlock everytime when a user get unlock.

oraclelocked
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Tariq Rahiman avatar image
Tariq Rahiman answered

Set the parameter PASSWORD_LOCK_TIME so that the users account will unlock after the specified time period. If this parameter is set to UNLIMITED it will never unlock.

http://www.orafaq.com/wiki/Oracle_database_Security_FAQ

1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

OraLearner avatar image OraLearner commented ·
Superb Tariq Rahiman. I thought of creating a procedure and schedule that procedure after a specified period of time. This option is really good one. Good that, I posted my question over here. :) Thanks a lot!!
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.