Notifications
Announcements
No record found.
Hi Everyone
I have a Business requirement where I have to show the changes made on user role with respect to the user including the deleted role on the form where we see the database log for user's. I'm able to show the Inserted type log in SecurityUserRole table by filter the tableid on the execute query event but not able to show deleted role because deleted role's logrecid is present in sysDataBaseLog but not in SecurityUserRole .
Pl give me idea's how to show the removed role on the same form respect to user, besides that database log description filed is empty for SecurityUserRole table.
Please help
Hi Vishu,
As far as I know the Fastpath ISV solution has that functionality built in.
https://www.gofastpath.com/
Not sure if this is an option for you because it requires some investment.
Irrespective of that, might be worthwhile having a look at their website and the solution offered.
Best regards,
Ludwig
Hi Ludwing thanks for the reply.
Basically I just have to customize the functionality of sysDataBaseLog for securityUserRoleTable.
What exact application are you working on? You posted the question in the Dynamics AX forum, but also used the tag D365.
For global tables, you have to switch to the 'dat' company to see the database log details. However, some system tables are not working correctly with the database log.
It would require a customization or ISV solution. Next to Fastpath, also To-Increase has a solution for security and compliance which includes extensive logging of security changes. www.to-increase.com/.../organization-structure
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 544 Most Valuable Professional
André Arnaud de Cal... 450 Super User 2025 Season 2
Sohaib Cheema 250 User Group Leader
