I need to enable DB level audit on a large number of databases.
DELETE - there are 2 mandatory fields - object name and principal name.
In object name: I can choose a list of all DB by clicking the check boxes however when I click ok, it only show name of one DB.
So does it mean only One DB is selected, or SQL server does not show all db names even if multiple are selceted?
Principle name is ok as I can select public to capture all users.
So idea is basically to capture DELETE operations on all DB in one DELETE category.