Data Management (DMS) provides the operation audit feature in addition to the basic features of operation log management. You can use this feature to troubleshoot database issues with ease and audit the operations that are performed on databases. You can also use this feature to view and manage the SQL statements that are used in the SQLConsole, tickets, logon information, and operation logs.
Features
Module | Description | Item |
---|---|---|
Operation Logs | Displays the logs of all the 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 the operations that are performed on the databases in DMS.
Note This module provides a user interface (UI) for you to audit operations in a centralized
manner. This also helps you troubleshoot database issues with ease.
|
Includes SQL statements that are used in the SQLConsole, tickets, and logon information.
Note Only DMS administrators, database administrators (DBAs), ticket submitters, and stakeholders
involved in the ticket approval process are allowed to view the ticket details.
|
Procedure and supported roles
Auditing dimension | Limit | Entry to operation audit | Supported role |
---|---|---|---|
Database | You can view and audit only the operations that are performed on the current database. |
|
You can be a DMS administrator, a security administrator, a DBA, a database instance
owner, or a regular user.
Note If you are a regular user, you can view and audit only the operations that you performed
on the current database.
|
Database instance | You can view and audit only the operations that are performed on the current database instance. | In the left-side navigation pane of the DMS console, right-click the database instance that you want to audit and choose Audit > Operation audit. | You can be a DMS administrator, a security administrator, a DBA, a database instance
owner, or a regular user.
Note If you are a regular user, you can view and audit only the operations that you performed
on the current database instance.
|
Global | You can view and audit all the operations that are performed in DMS. | In the top navigation bar, click Security and Specifications. In the left-side navigation pane, click Operation Audit.
Note If you use the previous version of the DMS console, move the pointer over the More icon in the top navigation bar and choose .
|
You can be a DMS administrator, a security administrator, or a DBA. |
Download operation records
This example shows you how to download all the SQL statements that are used in the SQLConsole in the last month.
Download operation logs
You can download operation logs only by calling the GetOpLog operation. For more information, see GetOpLog.