Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / How to show the databa...
Finance | Project Operations, Human Resources, ...
Answered

How to show the database log of SecurityUserRole table including the deleted role of the particular user

(0) ShareShare
ReportReport
Posted on by Vishu Beniwal 135

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

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,269 Super User 2024 Season 2 on at
    RE: How to show the database log of SecurityUserRole table including the deleted role of the particular user

    Hi Vishu,

    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

  • Verified answer
    Vishu Beniwal Profile Picture
    Vishu Beniwal 135 on at
    RE: How to show the database log of SecurityUserRole table including the deleted role of the particular user

    Hi Ludwing thanks for the reply.

    Basically I just have to customize the functionality of sysDataBaseLog  for securityUserRoleTable.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: How to show the database log of SecurityUserRole table including the deleted role of the particular user

    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

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.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans