[RANGER-771] 4+ Log entries upon login in in X_AUTH_SESS

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 0.4.0, 0.5.0
• Fix Version/s: 0.5.2, 0.6.0
• Component/s: audit, Ranger
• Assignee: Gautam Borad
• Reporter: Jorn Eilander
• Created: 07/Dec/15 15:18
• Updated: 12/Feb/16 01:18
• Resolved: 02/Feb/16 05:56

Description

I'm trying to implement Security Auditing (corporate) based on triggers in the Ranger database;

I can see 4+ login inserts in the X_AUTH_SESS table on a single login, on first glance they all look exactly the same. In an audit it would seem someone logged in 4+ times, which of course is not the case.

Perhaps a check, before writing to the table, if the same content is already in there?

Issue Links

• links to: Review request link