How Do I Verify My Database Audit Configuration?

To verify your database audit configurations after you enabled audit, perform the following steps:

1. Enter an SQL statement (for example, show databases) in the node where the agent is installed.
2. Log in to the management console.
3. Select a region, click , and choose Security & Compliance > Database Security Service. The Dashboard page is displayed.
4. In the Instance drop-down list, select the instance whose SQL statement information you want to view.
5. Click the Statements tab.
6. Click on the right of Time, select the start time and end time, and click Submit. The SQL statement entered in 1 will be displayed in the list. See Figure 1.
   Figure 1 Viewing SQL statements
   
   • If the entered SQL statement is displayed in the SQL statement list, database audit has been correctly configured.
   • If the entered SQL statement is not displayed in the SQL statement list, database audit is unavailable. Perform the following operations:
     • Disable database SSL. If SSL is enabled for a database, the database cannot be audited. For details, see How Do I Disable SSL for a Database?.
     • Rectify the fault by following the instructions provided in What Do I Do If the Communication Between the Agent and Database Audit Instance Is Abnormal?