Small and medium business | Business Central, N...

Permission set assignment

(4) Share

Report

Posted on by STP

731

Hi ya,

The end user is using NAV.

I don't find a report / export to excel to allow me to extract the users permission set assignment.

I'm checking who are using which permission sets in which company.

Can I use Configuration package to extract those data? what are the tables?

Or is there any other better way?

Thank you!

Categories:

Dynamics 365 Business Central

Microsoft Dynamics NAV

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Aziz Skhiri 230 on at

Like (1)

Report
Copy link

Link copied!

Hey! No, Configuration Packages won't work here (table 2000000053 = Access Control is a system table and blocked for export). Quickest way: run this simple SQL query in SSMS:

SQL

SELECT u.[User Name], ac.[Role ID] AS [Permission Set], ac.[Company Name] FROM [YourDatabaseName].dbo.[Access Control] ac INNER JOIN [YourDatabaseName].dbo.[User] u ON ac.[User Security ID] = u.[User Security ID] ORDER BY u.[User Name], ac.[Company Name]

Right-click results → Save As → Excel. Done in seconds. If no SQL access, ask your partner to whip up a tiny report/export super common request, takes them 5 minutes.

Was this reply helpful? Yes No
Suggested answer

Rajvi Shah 85 on at

Like (0)

Report
Copy link

Link copied!

Hello,

In the NAV you can check the permission set by below page.

you can click on CTRL + E to export the data in Excel.

Regards,

Rajvi Shah

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 98,569 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi, hope the following helps.

Dynamics 365 Business Central mini tips: How to assign Permission Sets to multiple users at the same time

https://yzhums.com/14740/

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

OussamaSabbouh 11,792 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hello,

Yes best source is table 2000000053 "Access Control"; that’s where NAV stores the user + permission set/role + company assignment, so it’s the right table to export if you want to see who has which permission set in which company. You might be able to use a Configuration Package, but for system tables it’s usually easier to create a quick query/report/page on Access Control and export to Excel. The key fields are usually User Security ID/User Name, Role ID, and Company Name; if Company Name is blank, that normally means the permission applies to all companies.

Regards,
Oussama Sabbouh

Was this reply helpful? Yes No