Dynamics Community Forum Thread Details

Exporting the Access Control table (2000000053)

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:

Administration and permissions

Reports and Business Intelligence

Other

Development

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. But this is somewhat clunky as it only copies the records visible/loaded on the screen so it will have to happen a few times with that many users.

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.