Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Great Plains - differe...
Finance | Project Operations, Human Resources, ...
Suggested answer

Great Plains - difference between 'sa' and system.admin account

(0) ShareShare
ReportReport
Posted on by RebeccaHornby 5

Hi - I am completely new to Dynamics applications but have been asked to start supporting a small Great Plains application used by about 12 of our finance department. Our license supplier has set me up as 'system.admin' but also provided a report extract of all existing accounts and I also see a 'sa' user account listed which seems to have access to all entities. can someone advise whether   one or both of these user accounts is the 'standard out of the box, default account' that would be available? and if one of these accounts is a master account?  

  • Suggested answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    RE: Great Plains - difference between 'sa' and system.admin account

    Ven is pretty much right with description of the 'sa' user.

    Here is a link to a white paper from FastPath about minimizing use of the 'sa' account in GP.

    www.gpug.com/.../DownloadDocumentFile.ashx

    PS: here's another thread with a similar topic: https://community.dynamics.com/gp/f/microsoft-dynamics-gp-forum/156798/using-the-dynsa-id-to-add-users

  • Suggested answer
    26P2ER Profile Picture
    26P2ER 1,773 on at
    RE: Great Plains - difference between 'sa' and system.admin account

    Rebecca

    Welcome to the Dynamics GP community. 

    The "sa" that you see is the absolute super master administrator. That is also the database system administrator "sa". They are one and the same. Good luck asking the password for the "sa" from the DBA group.

    The system.admin is probably something your "supplier" created for you to use. I am guessing giving you application level "power user" role.

    A given GP login (for the desktop client) will have a corresponding SQL login with the same name. However there is additional encryption in GP.

    A given GP login can have access to one or more companies or none. In each company the said login can have the same role or different roles.

    These are application roles.

    If you are able to go to the administration>User> add/change a new user with your system.admin GP login, then it is quite possible your supplier probably granted the prescribed SQL permissions in SQL database (such as sysadmin role for starters).
    If you are unable to add a new user or make changes to an existing user's password etc, you know you are not really a system administrator.

    Good luck!

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

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans