Data Management (DMS) provides the operation audit feature in addition to the basic features of operations log management. This way, you can identify and troubleshoot issues for databases with ease, and audit operations that are performed on the databases. You can also view and manage a list of SQL statements that are used in the SQLConsole, a ticket list, a logon list, and operations logs.
Features
Module | Description | Item |
---|---|---|
Operation Logs | Displays the logs of all operations that are performed in DMS. | Includes the logs of management and configuration operations, SQL statements that are used in the SQLConsole, tickets, and logon information. |
Operation audit | Displays all operations that are performed on databases in DMS.
Note This module provides a user interface (UI) for you to audit operations in a uniform
manner. This helps you identify and troubleshoot issues for databases with ease.
|
Includes a list of SQL statements that are used in the SQLConsole, a ticket list, and a logon list. |
Use the operation audit feature
Auditing dimension | Entry to operation audit | Supported role |
---|---|---|
Database
You can view only the auditing records of operations that are performed on the current database. |
|
You can be a DMS administrator, a security administrator, a database administrator
(DBA), an instance owner, or a common user.
Note If you are a common user, you can view only the auditing records of operations that
you perform on the current database.
|
Instance
You can view only the auditing records of operations that are performed on the current instance. |
In the left-side navigation pane, right-click the instance that you want to audit and select Operation audit. | You can be a DMS administrator, a security administrator, a DBA, an instance owner,
or a common user.
Note If you are a common user, you can view only the auditing records of operations that
you perform on the current instance.
|
Global
You can view the auditing records of all operations that are performed in DMS. |
In the top navigation bar, choose | .You can be a DMS administrator, a security administrator, or a DBA. |
View and download the auditing records of operations
This example shows you how to view and download a list of all SQL statements that are used in the SQLConsole in the last month.
Download operations logs
You can download operations logs only by calling the GetOpLog operation. For more information, see GetOpLog.