Hello dear Imperva community.
Life has developed in such a way that now I am responsible for the security of databases and I got such a wonderful tool as Imperva in my hands.
I am new to working with this system, but I already have respect for this software - they is amazing.
Unfortunately, I do not have experience in application, I would like to ask more experienced for solving the problem (or ideas for solving it).
Task:
As part of a scheduled audit, it is necessary to make a report on databse users who have not logged in for a long time (more than 6 months, additional control our IT Dep).
How I think this must be a like a report which will indicate
1) All users of the database
2) Last login date.
I tried to do that through policy and audit (additional field of the last time of the event).
I would be grateful for your help and experience!
*************************************************************************************************
How the additional information to my qustion:
I recive a report on users and their logins, but the report does not show all users (maybe, how is additional idea, make an separate report on database users)?
- I tryed, but report shows only users who have any event in DB (over a need period of time) and the end result i cant see not active users.
Any ideas?
#DatabaseActivityMonitoring------------------------------
Sergey Malovidchenko
Lead Engineer
Moscow
------------------------------