is it possible to log each permission granted to a specific user on a sql server instance?
for example if user A was granted sa -- make an entry to the log table
user A was granted dataread on database xyz -- make an entry to the log table
how can this be accomplish?