We have a policy to lock a user after 3 failed login attempts but this can cause problems for other users.
Is there a native way to prevent a user from locking account with the wrong password by doing something like
if failed login attempts = 2
where OS_USER=xxx and MACHINE=yyyy
then
prevent OS_USER=xxx and MACHINE=yyy from logging in.
and email DBA_GROUP and OS_USER that OS_USER is being bold.
end if
It could be coded without too much hassle from a login trigger I suppose but wondering if theres a native Oracle security policy that could be enabled that would do same.