web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Logging SecurityRoleTa...
Microsoft Dynamics AX (Archived)

Logging SecurityRoleTaskGrant

(0) ShareShare
ReportReport
Posted on by WGZ 12

Hey there,

I changed the EEUSerRoleChangeLog to have a functioning logging from Users - Roles, now I want Roles - Tasks also to be logged.

I see there is a table SecurityRoleTaskGrant, a system table, and I want to have the 'ModifiedBy' column added. I see there's a SQL query behind and that it retrieves data from some other tables as well, all stored in the model database. I was wondering if I could add a ModifiedBy column in the original tables that the SecurityRoleTaskGrant queries, maybe in SQl server or in AX2012. Because If I then include this data in a SCD Type 2 table I have my logging.

Any suggestions?

Kind regards,

Eric

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    nmaenpaa Profile Picture
    nmaenpaa 101,172 Moderator on at

    You should not make any changes in the model database.

    Also, remember that you can use the existing Database log functionality to track changes in tables.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 304,508 Super User 2026 Season 1 on at

    Hi Eric,

    It is not possible to add this field. Not by changing a property and adding a field in the model database is not recommended, like Nikolaos mentioned. Suppose you would have a field added in SQL, then you can't manage to get the correct value in it.

    I do assume, you want to have a logging on changes in the security roles itself. As the changes are meta data changes in the AOT, there is no control. You can install customizations (model, xpo) which contains security objects. Who did modify the role in this case?

    If you want to audit the changes, you could do this using source control systems. There are also some ISV solutions available who do support some analysis on security role changes.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
CP04-islander Profile Picture

CP04-islander 39

#2
Michel ROY Profile Picture

Michel ROY 14

#3
imran ul haq Profile Picture

imran ul haq 8

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans