Database Administrator at a insurance company with 10,001+ employees
Real User
Aug 5, 2018
Auditing. We mainly use it to follow up on changes to the individual databases. We audit exactly what the database administrators are doing. Those are the main two points. In some situations, we have the need to really audit everything that happens on a certain table, if there is any highly critical information there. We follow no particular regulation criteria. We have an individual catalog of potential issues, and we have a template that we are using. We did a risk assessment, and we identified several points that have to be checked by Compliance Manager and several other tools. We also use SQL Secure from IDERA. We established some custom counters in Diagnostic Manager, for example, to check certain parameters, just to make sure that everything is working as intended by us.
IDERA SQL Compliance Manager is an efficient auditing tool focusing on tracking and storing SQL activities for compliance and security purposes.IDERA SQL Compliance Manager offers a comprehensive database tracking approach, allowing for custom queries and email alerts. It effectively retains trace data for monitoring applications, aiding in security and SOX compliance by providing insights into elevated access. Its reports and cost-effectiveness stand out, although improvements are needed in...
Our primary use case for this solution is for controls, which we deploy on-premises.
It is mainly used to monitor and audit all SQL Servers, and data is being used by our Internal Audit team for SOX auditing.
We mostly use it so we can audit if a non-admin does something to a database.
We use it for auditing requirements. We also use it to identify activities, see what is going on, who is connecting.
Auditing. We mainly use it to follow up on changes to the individual databases. We audit exactly what the database administrators are doing. Those are the main two points. In some situations, we have the need to really audit everything that happens on a certain table, if there is any highly critical information there. We follow no particular regulation criteria. We have an individual catalog of potential issues, and we have a template that we are using. We did a risk assessment, and we identified several points that have to be checked by Compliance Manager and several other tools. We also use SQL Secure from IDERA. We established some custom counters in Diagnostic Manager, for example, to check certain parameters, just to make sure that everything is working as intended by us.