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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

Front end display of related security roles, privileges and permissions.

(0) ShareShare
ReportReport
Posted on by

Good day all

For D365, we are developing a product with a number of custom objects. I would like to create a tool allowing a relevant person to quickly see the securities associated with our custom objects (to ensure that appropriate securities have been setup). 

In 2012, i made use of something like this to populate a temp table:

SysSecObjectsInRole::GenerateData(userRightsTmp.SecurityRoleAOTName);

When you right click on a form for example, and navigate to 'Addins' and then to 'View related roles'. This form is very helpful: 

3482.Display2.png

Does anyone know which tables I can query to retrieve this data? 

In SQL I found a few of the tables with links between AOT objects and duties, privileges and permissions. One of them being this table: SECURITYRESOURCEPRIVILEGEPERMISSIONS. Unfortunately I cannot find this table in Visual Studio. 

Any input would be greatly appreciated. Thank you in advance. 

Kind regards,

Stephen

I have the same question (0)
  • Verified answer
    Blue Wang Profile Picture
    on at

    HI Stephen,

    Some of the content in cross references table are stored in serialized xml format.  There is no direct way to get all the cross references and permission details.

    community.dynamics.com/.../security-metadata-dump-from-dynamics-365-finance-and-operations

    If you want to use MenuItem, then you can check Security configuration form to get some information.

    Note: Moved to Finance Forum.

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…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 503 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 434 Super User 2025 Season 2

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 278 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans