[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Allow other user than SA to change passwords and access to companies

Posted on 2010-01-04
Medium Priority
Last Modified: 2013-12-11
Is there a way to allow another user than SA in GP to change users passwords or give access to different companies. Users forget the password or lock themselves out and we would like the IT helpdesk to deal with the password issues but we do not want to give the SA password to helpdesk staff due to security reasons.
Any suggestions?
Question by:JanFverhoeve
LVL 18

Accepted Solution

Steve Endow earned 2000 total points
ID: 26184301

That's a good question.  I just tried several different tests, and from what I can tell, there is only one way to allow someone other than 'sa' change the login.  I think it may work, but there may be a caveat that I'm missing.

Create a new GP login, and then only give that login access to the GP User Setup window.  (In GP 10, this should be easier than GP 9)

Then go into SQL Server Management Studio and add that login to the sysadmin server role.  GP checks to see if a login is a member of the sysadmin role to determine whether to enable the Save button on the User Setup window.

The user would then be able to login to GP, would only have access to the User Setup window, and would be able to change the GP passwords.

Because the login was created in GP, the user would not be able to use that login with SQL Server Management Studio, which I believe would prevent them from accessing anything on the SQL Server directly.

I think this would work, but as I said, there could be a few details I'm missing at the moment.

Let me know if that makes sense, and if you have any questions.


Steve Endow
Dynamics GP Certified Trainer
Dynamics GP Certified Professional


Author Comment

ID: 26188584
Thanks a lot for your suggestion. Tried it and it worked as expected and solves my problem.

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
Desired Skill Set for Microsoft Dynamics CRM Technical Resources – Part III
Viewers will learn how to maximize accessibility options in an Excel workbook for users with accessibility issues.
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

873 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question