I am doing auditing for all my sql server instances.
I came across a situation where the management is asking me to provide DATE and TIME the specific permissions were granted.
for example, there's a database user 'ABCD' , while creating this user I assigned data read/write permissions, lets say yesterday. Today I GRANT "Create Table" permission
to this user.
now I want to know the date and time the CREATE Table permissions were assigned to this ABCD user.
Anyhow there’s a column
View Complete Post