Question about AplexSql

Dear All,

I'm newbie in ApexSql.

I have some questions about the Audit.

1. Can ApexSql audit check the user that select data records more than normal, will be able to audit can show Alert or not
(sample normal, user Alice select data from table 'Revenue' only the current month but yesterdays her select data from 2019 and 2020)

2. Can ApexSql audit summary report about each user touched which table?

3. Can ApexSql audit analyze the behavior of each user that changed from normal?
(sample normal, user Alice using only the 'Revenue' table but yesterdays her select data from the Salary table)

4. Can ApexSql audit Check the behavior of each user that using privilege matches or mismatch with the permissions given.


5. Can ApexSql audit block some risky statement? sample delete from test without where clause.

Best Regards

  • Hello,

    Thank you for your interest in our products.

    1. Can ApexSql audit check the user that select data records more than normal, will be able to audit can show Alert or not
    (sample normal, user Alice select data from table 'Revenue' only the current month but yesterdays her select data from 2019 and 2020)?

    A: No, ApexSQL Audit won't throw an alert if a user constantly checks the records, however, you can choose to create a custom script to trigger this type of alerts or trigger an alert if a user have access to sensitive data in the alert wizard inside the tool, in addition the tool can throw an alert if certain users use a DDL command in the database.

    2. Can ApexSql audit summary report about each user touched which table?

    A: Yes, a report can show each user and table depending on the reporting config.

    3. Can ApexSql audit analyze the behavior of each user that changed from normal?
    (sample normal, user Alice using only the 'Revenue' table but yesterdays her select data from the Salary table)

    A: Yes and no, if you want the tool to automatically do this, you need to make a manual script to trigger this type of alerts, or have a person manually analyze the data to determine this type of behaviors in the tables.

    4. Can ApexSql audit Check the behavior of each user that using privilege matches or mismatch with the permissions given?

    A: ApexSQL Audit can record the activities made by all users in the database, but first the capture methods must be applied before attempting to record anything in the databases, you can also exclude certain users from the capture method if you want.

    5. Can ApexSql audit block some risky statement? sample delete from test without where clause?

    A: No, for this type of protection from accidentally executed SQL queries that can have a negative impact on the database we have ApexSQL Complete which is a free add-on for SSMS (follow this link: ApexSQL Complete)

    Hope this information is useful for you.