O&M Access Audit Query

Querying O&M Access Audit Records

1. Logging in to the Database Operations and Maintenance Management System using the secadmin Security Administrator account specified.
2. Select Behavioral Auditing> Ops Access Audit from the left navigation pane.
3. Filter logs via the following items:
   1. Enter the Access Time to search the log.
   2. Enter the platform User to search the logs.
   3. Enter the Statement Type to search the log.
   4. Enter the Access Tool name to search the log.
   5. Enter the Visitor IP address to search the logs.
   6. Select an Execution Status to search the log.
   7. Select the Response Action to search the log.
   8. Enter the Asset Control Name to search the log.
   9. Enter the Database Instance name to search the log.
   10. Enter the Table Name involved in the SQL query to search the log.
   11. Enter the Field Name involved in the SQL query to search the log.
       Figure 1 Operations and aintenance audit
       

       Table 1 Table1 Explanation of filter parameter specifications for the operations and maintenance audit list

       Parameter	Description
       Access Time	Platform user operation time.
       User	Operating platform username.
       Statement Type	The type of SQL statement executed by operations personnel when accessing the database, such as SELECT.
       Access Tool	The name of the client tool used by operations personnel to execute SQL statements in the database, such as WebSQL.
       Visitor IP	The IP address of the server hosting the client tool used by operations personnel to execute SQL statements in the database.
       Execution Status	The execution status (success or fail) of SQL statements executed by operations personnel when accessing the database.
       Response Action	The corresponding actions performed by operations personnel when accessing the database with SQL statements (No Permission, Block, All, SQL Replace, Table Replace, Field Desensitization, Fuzzy Desensitization, Audit, Row Access Control, and Suspend).
       Asset Control Name	Asset control name information.
       Database Instance	The database instance name or SCHEMA name involved in the SQL queries executed by platform users during operation and by maintenance personnel when accessing the database to retrieve data.
       Table Name	The table names involved in the SQL queries executed by operations personnel when accessing the database.
       Field Name	The field names involved in the SQL queries executed by operations personnel when accessing the database.