No relevant resource is found in the selected language.

This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies. Read our privacy policy>Search

Reminder

To have a better experience, please upgrade your IE browser.

upgrade

eSight V300R010C00 Maintenance Guide 07

Rate and give feedback :
Huawei uses machine translation combined with human proofreading to translate this document to different languages in order to help you better understand the content of this document. Note: Even the most advanced machine translation cannot match the quality of professional translators. Huawei shall not bear any responsibility for translation accuracy and it is recommended that you refer to the English document (a link for which has been provided).
SQL Server Audit Logs

SQL Server Audit Logs

This chapter describes how to set audit logs for the SQL Server database. Operations in this topic do not apply to the two-node cluster scenario.

Prerequisite

The database administrator can perform audit-related tasks such as starting or stopping data collection and viewing data collection logs using the object resource manager in the SQL Server Management Studio. Before specifying server audit rules, the administrator should create and configure the SQL Server audit objects.

Background

Audit logs of the SQL Server database should be viewed in the SQL Server Management Studio.

Procedure

  1. Start the SQL Server Management Studio.
  2. In the object resource manager, choose Security > Audits, right-click New Audit, and enter the audit name of a new audit task (for example, ServerAudit01). After that, set On Audit Log Failure to Continue, set Audit destination to Application Log, and click OK.

    1. Create a server audit rule and map it to the ServerAudit01 task created in the previous step. In the object resource manager, right-click Server Audit Specifications and select New Server Audit Specifications to access the Create Server Audit Specifications page.
    2. Set Audit name to ServerAudit01 and select an operation group for Object Class based on your needs. If you want to audit failed logins, select FAILED_LOGIN_GROUP.

  3. Perform the following operations to check the SQL Server audit logs:

    1. In the object resource manager of the SQL Server Management Studio, choose Security > Audits.
    2. Right-click audit logs to be viewed, select View Audit Logs, and view the logs in the Log File Viewer dialog box.

Translation
Download
Updated: 2019-06-30

Document ID: EDOC1100044373

Views: 24736

Downloads: 74

Average rating:
This Document Applies to these Products
Related Documents
Related Version
Share
Previous Next