web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Database production access

(0) ShareShare
ReportReport
Posted on by 30

Hi,

I am under external audit and a documentation of access to the production environment database was requested.

I know that access is exclusive to Microsoft, but I haven't found any official documentation where there is this information explicitly.

Do you know where I can find this information?

I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    301,171 Super User 2025 Season 2 on at

    Hi Eduardo,

    I can't find the statement quickly either. You can read the architecture documentation where it is stated that some Azure services are used "under the hood": docs.microsoft.com/.../architecture-overview

    If the external auditor is from a known auditing firm he should also have some Dynamics 365 experience and know that direct database access is not possible for customers and partners.

  • Suggested answer
    Alireza Eshaghzadeh Profile Picture
    14,686 Super User 2025 Season 2 on at

    Hi Eduardo,

    I completely agree with André.

    There can be option that auditor get access to D365FO Prod with just read access (i.e. assign auditor with a role that she can have read access to required tables and reports e.g. Voucher transaction.

    Or you perform a database refresh from prod to UAT where the auditor can get access to the database via SQL management studio or eventually getting data directly from reporting tool (e.g. PowerBI)

    Best Regards,

    Alireza

    Alireza Eshaghzadeh | Business Consultant

    This post is my own opinion and doesn't necessarily reflect the opinion or view of my company or Microsoft

  • Suggested answer
    Gaurangkumar Jani Profile Picture
    4,534 User Group Leader on at

    Hi Eduaro,

    Why do auditors need DB acess?

    Do they need specific details from FO? Can't we provide using OOB functionality/reports?

    Is your auditor use a separate auditing tool for which they are looking for a data dump?

    Can't you create ER Report as per the requirement?

    If this is a local (Brazil specific) requirement please check the localization available in D365FO:

    BZ : docs.microsoft.com/.../brazil

    NL : docs.microsoft.com/.../emea-nl-audit-file

    Thanks,

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 467 Super User 2025 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 420 Most Valuable Professional

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 241 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans