Skip to main content
Post a question

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id : TP7dF1BzqWnK9p2SPlsS6X
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Accessing D365 Table B...
Finance | Project Operations, Human Resources, ...
Suggested answer

Accessing D365 Table Browser for non-sysadmin user

Like (1) ShareShare
ReportReport
Posted on 17 Mar 2025 01:21:48 by CU17030119-0 2
Is there anyway that a non-System Admin user can access the D365 table browser? If so, how do I configure the security for the role? It seems like only system administrator can access that, and even Information Technology Manager can't access the the table browser.
 
Categories:
Dynamics 365 Finance
  • Suggested answer
    Jonas "Jones" Melgaard Profile Picture
    Jonas "Jones" Melgaard 2,953 Super User 2025 Season 1 on 17 Mar 2025 at 11:52:17
    Accessing D365 Table Browser for non-sysadmin user
    It is not possible for non-admins without customizations. See this thread: Table Browser Security Problem
    Why is it so that you want non-admins to use the table browser? It's a potential security and compliance risk
  • Suggested answer
    Daivat Vartak (v-9davar) Profile Picture
    Daivat Vartak (v-9d... 2,372 Super User 2025 Season 1 on 17 Mar 2025 at 04:37:00
    Accessing D365 Table Browser for non-sysadmin user
    Hello CU17030119-0,
     
    You've hit upon a key security restriction in Dynamics 365. The systablebrowser menu item is indeed exclusively accessible to users with the System Administrator role. This is a deliberate security measure by Microsoft to protect the underlying data model of the system.
     
    Why the Restriction?
    • Data Integrity: The table browser provides direct access to the Dataverse database schema and data. Allowing unrestricted access could lead to unintentional or malicious data modifications.
    • Security Risk: Exposing the table browser to non-administrators increases the risk of unauthorized access to sensitive data.
    • System Stability: Incorrect use of the table browser could potentially disrupt the stability of the Dynamics 365 environment.
     
    No Supported Way for Non-Admins to Access:
    • Security Roles: There is no security privilege that can be granted to non-System Administrator roles to enable access to the systablebrowser.
    • Customizations: Modifying the system to bypass this restriction is highly discouraged as it could lead to unsupported configurations and potential security vulnerabilities.
     
    Alternative Approaches (For Non-Admins):
    While direct access to the table browser is restricted, here are some alternative approaches for non-admin users to access and work with data:
    1. Advanced Find:
      • This is the primary way for non-admins to query and retrieve data.
      • Users can create and save views to access specific data sets.  
    2. Views and Dashboards:
      • Administrators can create views and dashboards that provide non-admins with access to relevant data.  
    3. Power Apps:
      • Power Apps can be used to build custom applications that provide tailored data access and manipulation capabilities.  
    4. Power BI:
      • Power BI can be used to create interactive reports and dashboards that visualize Dynamics 365 data.  
    5. Dataverse Web API:
      • For developers, the Dataverse Web API provides programmatic access to data.  
      • This requires appropriate permissions and authentication.
    6. XrmToolBox:
      • This is a community developed tool that can be used to view system metadata, and data.
      • This tool will still require the user to have appropriate permissions to the data.
     
    Information Technology Manager Role:
    • The Information Technology Manager role is designed for managing system configurations and settings, but it does not grant access to the table browser.
    • This role provides a balance between administrative control and data security.
     
    Key Takeaway:
    • The systablebrowser is intentionally restricted to System Administrators for security and data integrity reasons.
    • Non-admins should use alternative methods like Advanced Find, views, and Power Apps to access and work with data.
    If my answer was helpful, please click Like, and if it solved your problem, please mark it as verified to help other community members find more.
    If you have further questions, please feel free to contact me.
     
    My response was crafted with AI assistance and tailored to provide detailed and actionable guidance for your Microsoft Dynamics 365 query.
     
    Best Regards,
    Daivat Vartak

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,916 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,782 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans