I m new to database security monitoring. One of my challenge is to monitoring someone extracting information like 10000 account numbers stored on database.
I can look at sql statements during monitoring but cannot get exact number of count that person is extracting from DB.
how could i able to monitoring exact number of count that each record is extracted from logs available? this is for PCI compliance.
could we create a SQL statement to find the count?
any help in achieving this is appreciated.