Manage database logs

Database logs contain sensitive data. By default, any user who has database access can query a database log by using Business Connector, X++, or alerts, or by using direct database access. To protect data, restrict permissions on the sysdatabaselog table. For more information, see "Manage table and field access" in the System and Application Setup Help, available from the Microsoft Dynamics AX Help menu.

Consider carefully which tables you select for database logging. For example, logging changes in transaction tables where there are often many changes has a negative impact on overall system performance. To limit log entries and to improve performance, select specific fields to log instead of entire tables. For individual fields, only updates can be logged.