How do I record User changes in the database log?

(0) Share

Report

Posted on by Community Member

I have set up the recording of user deletions but would also like to record changes to user details such as the addition or removal of security roles.

For user deletions I selected table "User Information" and clicked Delete.

For user changes I tried selecting the same table and clicked Update but no changes are being recorded.

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (1)

Suggested answer

guk1964 10,886 on at

Like (0)

Report

RE: How do I record User changes in the database log?

There is some localization code for this (EEUR) Permission changes log (report) [AX 2012]

Generate and print a report that displays changes to an employee’s permissions to access information, security rights, or user role in Microsoft Dynamics AX. You can select to view the permission changes as an overall list for the employee, or as a breakdown of tables and fields.”

This article describes the use of the underlying log table and business logic.

https://blogs.msdn.microsoft.com/axsupport/2016/04/06/dynamics-ax-2012-audit-of-security-role-membership-changes/

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: How do I record User changes in the database log?

Thanks Martin, I've downloaded the XPO and will see if it works for me.

Was this reply helpful? Yes No
Verified answer

Martin Dráb 236,206 Most Valuable Professional on at

Like (0)

Report

RE: How do I record User changes in the database log?

A similar question was discussed in an older thread: Database Log - changes to security roles being audited?.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: How do I record User changes in the database log?

That's not a relevant link.

Under "Database log setup" I have set "Security user role" on for Delete and Insert but when tested the log entries don't identify either the user or role being deleted/inserted.

Was this reply helpful? Yes No
Pravasti AK 2,985 on at

Like (0)

Report

RE: How do I record User changes in the database log?

hi,

Please find the below link:

https://kaya-consulting.com/how-to-rename-records-in-ax7/

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: How do I record User changes in the database log?

Yes I've set up database logging before.

Just need help with recording user changes.

Was this reply helpful? Yes No
Suggested answer

Pravasti AK 2,985 on at

Like (0)

Report

RE: How do I record User changes in the database log?

Hi,

You can use database logging for tracking specific types of changes to AX tables and fields. When you configure logging for a table or field, a record of any change to that table or field is stored in the database log table, sysdatabaselog, in the AX database.

You can use the Logging database changes wizard to set up database logging. The wizard provides a flexible way to set up logging for tables or fields.

Click System administration > Setup > Database > Database log setup. Click New to start the Logging database changes wizard.

Complete the wizard

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: How do I record User changes in the database log?

It looks more complicated than using the AX GUI.

Was this reply helpful? Yes No
Suggested answer

Pravasti AK 2,985 on at

Like (0)

Report

RE: How do I record User changes in the database log?

Hi,

Please follow the below link it will guide u better,

http://floditt.blogspot.fr/2011/08/simplify-tracking-changes-with.html

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: How do I record User changes in the database log?

I am using database logging. I just need guidance on how to record user changes.

Was this reply helpful? Yes No