4 ms·
How can the access log help you? Presumably only the sysadmin and the EMR application should have SQL accounts; the only person this guards against is the sysad
by closeparen 10y ago
How can the access log help you? Presumably only the sysadmin and the EMR application should have SQL accounts; the only person this guards against is the sysadmin, unless the application passes through the user ID it's querying on behalf of somehow? Otherwise, you know that a query happened but not who ran it.
- dogma1138 10y agoYou need to be able to trace individual queries which MSSQL also makes it easy since you can pass the user identity and map it to a set of credentials on the DB side automatically. But in general again this isn't about security it's about complience so it's more about doing things by the book and a very specific one.