Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Exporting the Access C...
Small and medium business | Business Central, N...
Suggested answer

Exporting the Access Control table (2000000053)

(1) ShareShare
ReportReport
Posted on by Pascal Aaldering 10
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:
Business Central
Business Central
Business Central
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 73,696 Super User 2024 Season 2 on at
    Exporting the Access Control table (2000000053)
    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
  • Pascal Aaldering Profile Picture
    Pascal Aaldering 10 on at
    Exporting the Access Control table (2000000053)
    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
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 73,696 Super User 2024 Season 2 on at
    Exporting the Access Control table (2000000053)
    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.
     
    Thanks
    ZHU
  • Pascal Aaldering Profile Picture
    Pascal Aaldering 10 on at
    Exporting the Access Control table (2000000053)
    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
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 73,696 Super User 2024 Season 2 on at
    Exporting the Access Control table (2000000053)
    Hi, hope the following can give you some hints.
     
     
    Thanks.
    ZHU
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 24,822 Super User 2024 Season 2 on at
    Exporting the Access Control table (2000000053)
    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. 
     

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans