I need to set up a SQL Server audit to capture all database activity for all logins except one - the login our application runs under. In this case the login I want to exclude is CPSDOM\cpointedb.
In SQL Server Management Studio under 'Security / Logins' I see the login CPSDOM\cpointedb. But, when I look under 'Databases / dbName / Security / Users' I do not see the user CPSDOM\cpointedb.
When I set up my Database Audit Specification I also do not see CPSDOM\cpointedb user. I was hoping to see this user listed in the Database Audit Specification so I could check all the users except that one.
Is there a different (better) way to do this? All I want to do is set up an audit that excludes one user.
Aucun commentaire:
Enregistrer un commentaire