question

OraLearner avatar image
OraLearner asked

how to increase number of login attempts?

My user account is being locked after 3 wrong password entries.

As my team is using same user, the account being locked is very frequent.

Is there anyway we can increase this limit to atleast 10. So I don't need to unlock again.

loginlocked
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.

2 Answers

·
Tariq Rahiman avatar image
Tariq Rahiman answered
  1. Create a profile
  2. Alter the user to belong to the profile group
  3. Alter the profile to increase the login attempts to 10 using

alter profile profile_name set failed_login_attempts = 10;

Resource with explanation and sample code ::

http://www.dba-oracle.com/t_password_security.htm

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 ·
Thanks a lot Tariq Rahiman!! Now I am able to increase the limits.
0 Likes 0 ·
HillbillyToad avatar image
HillbillyToad answered

Instead of decreasing security on the database, you should have separate accounts/logins created for each person. That's just an opinion of course...

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 ·
Yes You are right. Its a valuable and reasonable suggestion. I need to check this out. Thank you very much for pointing this out.
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.