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

Notifications

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) / Security Key Report
Microsoft Dynamics AX (Archived)

Security Key Report

(0) ShareShare
ReportReport
Posted on by karenM 140

I need to be able to see all the security keys in my system and what level of security each user group has against each one. Ideally I'd like to see all security keys in a list and then each user group permissons against each one.

At the moment the only way I can see of doing this is via administration -> Reports -> Security -> User Groups Security. Considering that I have quite a few user groups in various companies this is a very time consumming task.

Is there a way of getting this information out other than the user group security report for each user group and exporting to excel etc. I've tried to look at the database table to see if I can write a query but can't see the security system tables.

I'd be grateful for any suggestions.

Regards

Karen

 

 

 

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Hi Karen,

    You can find that information in table AccessRightsList.  This table lists each security key and its access type per user group.  Note that any access type of full control is not stored in the table.  

    Kind regards.

  • karenM Profile Picture
    karenM 140 on at

    Thanks Kent,

    How can I link the id to the security key ? Can I get a list of the security keys and their associated ids out of the system ? Why wouldn't it display full control ?

    Regards

    K

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    You can see the list of relations in the help menu for that table.  Found in AOT > System Documentation > Tables > AccessRightsList.  

    Documentation is few and far between on security since these are for the most part all system tables / classes.  I believe element name in AccessRightsList is key.  You can also take a look at SysSecurity classes to see how the security tree is built and how data is associated.  It does not display full control since the system does not need to do anything to enforce security on the keys, so it doesn't need to store it in the first place.

    I would also suggest looking at class SysUserGroupSecurity which is what is run when you run the security group report you mentioned.

    EDIT:  You can also run the security group report and save it as a text file so you can dump it into excel.  Initial setup will take some time but after that you should have quick access to all the permissions in an excel file saved on your computer.  Might be an easier solution then coming up with your own report.

  • karenM Profile Picture
    karenM 140 on at

    Thanks Kent,

    I think I'll persevere with building the spreadsheet.

    Regards

    Karen

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans