SQL Census was designed to give you a good top down view of who can do what in your estate. This article explains how exactly it works.
In this blog post, we’ ll outline a couple of the most common scenarios we heard in our early research and describe how SQL Census can be used to prepare for a smooth audit and easily provide your auditor with the information they need.
We all work to best practices, but it’s not easy to get a good top down view of who can do what in your estate. We’ ve designed SQL Census to give you that view at a click of a button. Let’s explore this scenario.
Now let’s look at these Read/Write permissions – it doesn’ t look like Ali’s login has been granted anything specifically on the server. So what’s going on?
Now it’s much easier for DBA Debs to see what’s going on, and take action if necessary.
Our aim is that SQL Census becomes the standard-bearer for SQL Server audit reports. That’s why we’ re working with auditors and IT audit consultants to make sure SQL Census creates reports that are easy for your auditor to follow, provides all the user access evidence needed for the audit, and is simple to export.
This information is collected in a report that’s easy to generate, is simple to export, and is trusted.
