Question on Audit group - DATABASE_OBJECT_CHANGE_GROUP
Posted on 2016-11-04
I tried configuring DDL audit for my production databases, while doing so I am unable to find ways to selectively collect data for few logins and leaving the other logins used by applications.
But in case of DML operations such as select,update,delete,execute are able to be configured for each user individually.
Could someone shed some light on why aren't we able to configure the DDL statement audit for each individual logins?
Environment details: SQL server 2008 R2 service pack 2