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

Exporting the Access Control table (2000000053)

(5) Share

Report

Posted on by Pascal Aaldering

Hi,

For auditing purposes, I am looking to export the Access Control table from a full-SaaS Business Central environment.

Reason: this table gives full insight in assigned permission sets to users.

The 'Permissionset per User' screen only shows the assigned permission sets for 10 users at a time. This means that a client with over 400 users, needs to make 40 exports to Excel to get full coverage of all users and their assigned permissions.

What would be the easiest way to export this information from the system?

(I have tried configuration packages, but it will not let me export the Access Control table (2000000053))

Thank you,

Pascal

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

Valentin Castravet 31,586 Super User 2025 Season 2 on at

Like (2)

Report
Copy link

Link copied!

If you open the Table Information Page, you can open table 2000000053 from there. In the table you can then copy paste the records to excel.

If it was me I would get this free Business Central app called 'Table Data Editor' https://vld-nav.com/table-data-editor-for-bc, with this app you can open table 2000000053 and it has the Open in Excel option. Just be careful with this app as it can edit posted data, perhaps uninstall it after you're done so other users don't use it.

Alternatively, you can get a developer to quickly create a custom page for this table, they can also add the Export to Excel action on the page, you can then use the Export to Excel action on the new page. Or the developer can create a new report with the data item being the table.

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,987 Super User 2025 Season 2 on at

Like (2)

Report
Copy link

Link copied!

Hi, hope the following can give you some hints.

https://yzhums.com/8417/

Thanks.

ZHU

Was this reply helpful? Yes No
Pascal Aaldering 29 on at

Like (2)

Report
Copy link

Link copied!

Thank you for the responses.

The Table Data Editor is a non-native BC add-on. Since we will be asking clients to export data, I want to use native BC/Microsoft functions for this task.

The fact that you can view a table through a URL is helpful, but also frustrating since you can not export this (or atleast not the full table).

Yzhums article mainly shows how to develop a new page that shows the requested information. To what extent is this possible for a full-cloud SaaS BC environment (where development capability is limited, or where the client does not have sufficient knowledge to go this route).

Is there a native Microsoft/BC way to export this data, without too much customizationt?

Pascal

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,987 Super User 2025 Season 2 on at

Like (2)

Report
Copy link

Link copied!

Hi, If you have opened the table, you can also scroll all the way to the bottom and copy all the rows... Microsoft mentions there is no limit.

https://learn.microsoft.com/en-us/dynamics365/business-central/faq-copy-paste?wt.mc_id=DX-MVP-5004336#what-is-the-maximum-number-of-rows-that-can-be-copied

Thanks

ZHU

Was this reply helpful? Yes No
Pascal Aaldering 29 on at

Like (2)

Report
Copy link

Link copied!

Hi,

Thank you. Scrolling to the bottom and copying does indeed work. For (relatively) small tables this seems like a good solution.

For larger tables (such as 17 - GL Entry), this will be challenging due to a long time spent scrolling, but also memory limits when actually copying.

Is there a best practice to export larger datasets from BC? The configuration packages work, but the limit there is Excel. For tables with more records than the Excel limit, this will be an issue (let alone the time/memory it consumes).

Thanks,

Pascal

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,987 Super User 2025 Season 2 on at

Like (2)

Report
Copy link

Link copied!

For tables that cannot be exported using Configuration Package, such as system tables and virtual tables, you can open them directly to copy and paste.

For tables that can be opened using Configuration Package, exporting with it is the fastest.

Or you can use Open in Excel directly, but this requires a list page and the fields are also limited.

Thanks

ZHU

Was this reply helpful? Yes No
Pascal Aaldering 29 on at

Like (1)

Report
Copy link

Link copied!
Hi all,

I want to revisit this question. We have found out that exporting the Access Control table through the URL, and copy/pasting the tables to Excel is a feasible option for smaller entities.

For larger setups, this requires the system administrator to scroll all the way to the bottom of the table, and exporting it (correctly).

This is error-sensitive and inefficient.

Options we have explored:

Configuration Packages: Drawback -> Not allowed for system tables (which Access Control is)

Direct Excel export from 'Permission set per User' page: Drawback -> Only exports 10 users per page

Copying rows from 'URL.com/table=XXX': Drawback -> Prone to errors and time consuming for very large entities.

The goal is to obtain an overview of all users and their permissions (CSV/Excel preferably), also for larger BC setups with multiple companies. A generic export method would be preferred, so that it can be reproduced per entity/organization providing the same export (given ofcourse that the BC version is identical, and no customization is applied).

Hoping you have any experience in making this type of export more robust.

Thank you,

Pascal

Was this reply helpful? Yes No