D365FO - SQL get security details (such as Security roles, duties and privileges)

D365FO - SQL get security details (such as Security roles, duties and privileges)

Learn how to obtain detailed information about security roles, duties, and privileges in D365FO through SQL queries in this post. Whether you need to get a list of security roles, security roles to duties, security roles with privileges or a list of all role-duty combinations with privilege, this post has got you covered.

The SQL queries in this post are organized in a manner that covers various combinations of data. The following tables have been used:


The post includes SQL queries to get the list of all security roles, security roles to duties, security roles with privileges, and a list of all role-duty combinations with privilege. With this information, you can make informed decisions about user and role assignments and ensure that your system is secure.

Check out the referral link to discover these valuable SQL queries.

Published on:

Learn more
Sherif Fayed
Sherif Fayed

Share post:

Related posts

Power BI's Security Arsenal: Row-Level Security Explained

When it comes to analytics reports, data security is of paramount importance. Power BI, a popular analytics tool, offers a critical security f...

9 months ago

Security Features in Microsoft Dynamics 365 (CRM) Online

If you're working with Microsoft Dynamics 365 (CRM) Online, it's crucial to understand the built-in security features that can help safeguard ...

1 year ago

Get Current User's Security Roles

This post is a quick guide to obtaining the security roles of the current user in Microsoft Dynamics 365. While working within the platform, i...

2 years ago

The Public Preview of the Modern Security Role setting URL redirection and the Modern Security Role setting interface are available to users that have access to the security role setting in the Dynamics 365 portal.

The public preview of the modern security role settings URL redirection and interface is now available for users who can access the security r...

3 months ago

Dataverse | ‘App Opener’ security role

Discover the new 'App Opener' security role in Dataverse with this informative post originally published on the Microsoft Power Platform blog ...

1 year ago

Good Practice: Use Security Groups in Role Mapping Instead of User Accounts in Power BI Row Level Security (RLS)

This article talks about the best practice to use security groups instead of user accounts in role mapping while implementing Power BI Row Lev...

1 year ago

Show/Hide ribbon button based on Security Role without writing code in Dynamics 365 CE?

If you're looking for a way to show or hide a ribbon button on Dynamics 365 CE based on a user's security role without writing any code, then ...

1 year ago

What are the mechanisms for boosting data security with Microsoft Dynamics CRM security?

As businesses increasingly rely on CRM systems for storing critical information, data security has become more important than ever. Microsoft ...

1 year ago

Row Level Security & Object Level Security In Power BI DAX Studio

In this tutorial, you'll gain valuable insight into testing Row Level Security (RLS) and Object Level Security (OLS) in Power BI DAX Studio. B...

1 year ago
Stay up to date with latest Microsoft Dynamics 365 and Power Platform news!
* Yes, I agree to the privacy policy