Database log setup (form) [AX 2012]

Updated: May 10, 2011

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.

NoteNote

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.

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

Button

Description

New

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

Delete

Removes a database log from the list.

NoteNote

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

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.

NoteNote

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).

Community Additions

Show: