sap - HANA - user getting deactivated due to wrong credentials -
we have sap hana database, have 1 db user shared across 100 users (may not best practice). coming across situation user getting deactivated due connection attempt wrong credentials. maximum_invalid_connect_attempts 6. possible find out last application users or os users have tried connect wrong credentials.
we thinking of increasing maximum_invalid_connect_attempts , number of users. before that, there way find application user/os users trying connect wrongly?
best regards
we have 1 db user shared across 100 users (may not best practice)
there no ambiguity here, not "not best practice" it's plain wrong share user account across multiple end users. doing that, abandon account related security , problem seem face direct consequence of that.
to find out os user tried log on system (successful or not) db auditing needs configured. action needs audited validate user , available hana 2.
you can of course disable whole max_invalid_connect_attempts don't seem worry db access security anyway.
Comments
Post a Comment