Database log setup (form)

  • Article

Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012

Click System administration > Setup > Database > Database log setup.

Use this form to view a log file that contains table and field changes.

Note

Database logs can contain sensitive data. By default, any database log can be queried by any user who has access to the database. Users can query the log by using Business Connector, X++, alerts, or by using direct access to the database. To protect data, restrict the permissions in the sysdatabaselog table. For more information, see the Microsoft Dynamics AX developer documentation.

Task that uses this form

Configure and manage database logging

The following table provides descriptions for the controls in this form.

Buttons

Button

Description

New

Opens the Logging database changes wizard to configure logging for a table.

Delete

Removes a database log from the list.

Note

To support auditing, records that have been signed cannot be deleted from logs. For more information, see Electronic signature overview.

Fields

Field

Description

Table name

The name of the database table to be recorded in the log file.

Field name

The name of the table field to be recorded in the log file.

Type of change

The types of changes to the specified table or field to be recorded in the log file. Types include the following:

  • Insert

  • Update

  • Delete

  • RenameKey

Signature controlled

Indicates whether changes to the table or field require a signature.

Note

To enable auditing, records that have been signed cannot be deleted from logs. For more information, see Electronic signature overview.

Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).