Notifications
Announcements
No record found.
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?
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!
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
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 660 Most Valuable Professional
André Arnaud de Cal... 549 Super User 2025 Season 2
Sohaib Cheema 307 User Group Leader
