Finance | Project Operations, Human Resources, ...

Security Database Log

(1) Share

Report

Posted on by Zoran Golomeov

108

Hi all,

How can I track changes on security level (Roles/Duties/Privileges) within the database log? (or any other way)

Regards

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Navneeth Nagrajan 2,138 Super User 2025 Season 2 on at

Like (0)

Report

Security Database Log

Hi Zoran,

You can refer to System administration -> setup -> Database log setup -> New ->SecurityUserRole under System Node.

Note: Would suggest to be careful with the space consumption at the database level if you are enabling database logging at the table level.

Reporting:

There are some standard reports available in D365 FO. You can refer to these reports to track the changes at the Roles, duties and privileges level. This is available under System Administration -> Enquiries -> Security.

These are the standard reports available out of standard D365.

There have been some discussions in the past about the same in the community.

References:

Database Log - changes to security roles being audited?

Logging changes in security setup

Additionally, there are third party tools available in the Microsoft appsource space too like FastPath that be used as a third party tool for database logging at the table level (if there is a worry about the database log space consumption).

Fastpath Assure for D365

Hope this helps.

Was this reply helpful? Yes No
Suggested answer

Jonas "Jones" Melgaard 4,798 Super User 2025 Season 2 on at

Like (0)

Report

Security Database Log

Hi Z,

The answer is it depends.. This is for AX2012.

If it's role assignments, then there is this nifty trick to use some country-region functionality to track changes: https://www.microsoft.com/en-us/dynamics-365/blog/it-professional/2016/04/06/dynamics-ax-2012-audit-of-security-role-membership-changes/

If it's actual Role/Duty/Privileges changes, then you need to implement some kind of version control. Either MorphX or TFS: https://learn.microsoft.com/en-us/previous-versions/dynamicsax-2012/developer/configuring-version-control-in-microsoft-dynamics-ax?redirectedfrom=MSDN

Was this reply helpful? Yes No