A client recently had some changes in their IT department that required the accounting department to no longer use the System Administrator (SA) user. In order to use an existing Dynamics GP user account or create a new user account with SA-level permissions, the following permission and access need to be assigned.
Dynamics GP Steps
First, open Dynamics GP. Navigate to the User screen, and then Setup New User, if needed.
Now, on to User Access. Assign access to companies.
Next, navigate to User Security, and assign Power User permissions.
SQL Steps
Next, you need to open SQL and navigate to the SQL User Account. Assign SECURITYADMIN server role.
Now it’s time to Change Role Membership. Head over to Database User Account –> Database Role Membership. The roles need to be assigned at Dynamics DB and all Company databases.
- Assign DB_DATAREADER
- Assign DB_DATAWRITER
- Assign DB_ACCESSADMIN
- Assign DB_SECURITYADMIN
And now your System Administrators are all set. Be sure to subscribe to our blog and our YouTube channel for more tips!
