http://goo.gl/EmKxy0

Archive

Posts Tagged ‘login’

How to lock last login with “sa_role” role

February 24th, 2013 No comments

By default ASE doesn’t allow ¬†to lock last unlocked login that have sa_role/sso_role role. However, it can be locked if a role has explicit password set to enable the role while login.

If a role is altered to have a limitation on failed attempts, and a login attempts to enable the role and fails the required number of times, the role is locked for all holders of the role. ¬†Likewise, since we can’t explicitly lock the last unlocked login with sa_role or sso_role, it is possible for failed login attempts to indirectly lock that login.