March 3, 2015 at 12:27 am
Hi,
I am using database which is having sensitive data and all users are having permission for using select query. So, Please assists me how can i track the user who is using select query to access the database and also i should receive mails if anyone use this database, select query also i should receive mail.
Thanks,
Babu
April 21, 2015 at 11:03 am
First of all if you have a large system and that table is queried a lot you would get a TON of emails.
I don't know if there is a way to do what you want to do.
Maybe you should go about it in another way. Generate a list of all userids that have select, insert, update, delete to that specific table (remember data_reader and data_writer get access to all tables in the db as well) and take that list to the data owner and have them tell you if everyone on that list should have access. If not, remove them.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply