Database log for user role changes

(3) Share

Report

Posted on by YOG

420

Dear Expert,

Which table do I need to activate log for, in order for me to track user role changes?

I've enabled log for following tables and made changes to test account but changes are not being tracked

User security role
User log table

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Verified answer

André Arnaud de Cal... 304,711 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi YOG,

Can you share a screenshot of the database log setup wizard and enable also the option to show table names? Then I can verify if you have the correct table. The table which is working for me is Security User Role (SecurityUserRole). The identification details are not showing; only the field details itself. The role is presented with a reference record ID. To translate it to a certain security role, you would need to have a list of the roles including the record IDs.

Was this reply helpful? Yes No
YOG 420 on at

Like (0)

Report
Copy link

Link copied!

Thanks Andre,

I can see log with Record ID

I was expecting info from client screen.

Was this reply helpful? Yes No
Mandeep.S 283 on at

Like (0)

Report
Copy link

Link copied!

Hi folks,

I have the same question, my D365 is on-prem FnO 10.0.43 and I want to track all User Role changes for audit compliance.

I have enabled database logs for SecurityUserRole and SysUserInfo at the table level (first line only) for New Transactions/Update/Delete/Rename.

Now the issue is that after making a role change I can see the database log for it (first line in the screenshot below), but it does not provide any information about the change itself, it just logs that there was a change- - created by, created date and time. There is no information on what the role change was, which user was it for etc.

How do i get the details of the Role change in the database log?

Any light on the subject will be appreciated. Thanks

Was this reply helpful? Yes No
Sohaib Cheema 49,679 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi,

With the new USG, you have the Role audit trail, without you needing to enable the database log.

1 people found this reply helpful.

Was this reply helpful? Yes No
Mandeep.S 283 on at

Like (0)

Report
Copy link

Link copied!

Thanks for responding Sohaib,

Is this feature a Cloud only feature (I'm on-premise) and which version onwards is it available?

Was this reply helpful? Yes No
Sohaib Cheema 49,679 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @Mandeep.S

Which feature are you talking about?

If you are referring to USG, it should be available in all versions (on-prem and cloud).

The only reason I can think of for it not being available in your system is that the feature is not enabled, which you can turn on from Feature Management

Was this reply helpful? Yes No