Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Answered

Error when copy User Settings

Posted on by 25

Hello,

I have an issue when I try to copy the setting from an existed user to another existed user. I want 2 this users have the same assess rights and setting when they work on GP but don't want to grant the access  rights one by one from user A to user B. Does any one know which is the issue? Do Dynamics GP allow to do this or this feature limits some?

pastedimage1643153134020v1.png

Best Regards,

John Nguyen

  • Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: Error when copy User Settings

    This is a super frustrating problem that is often encountered when you restore a database from production to test.   A user that is in this situation can not be fixed in the application - the only solution I know of, and of course which Derek has mentioned in his post, is to remove the user from the company database that generates the problem and unfortunately that can only be done in SQL Management Studio.


    This would be a great suggestion for an future update - allow for the management of users at the SQL database level - from within the Dynamics GP application - thereby removing the SQL Management Studio from the problem.

  • Suggested answer
    RE: Error when copy User Settings

    No, because the issue is there is a mismatch between GP not thinking the user has access to the company databases, and SQL thinking/showing they do.

    We have to go into SQL and remove the users from the GP company databases, in order to then give them access again via GP, which will synch both of those together again.

  • john.nguyen Profile Picture
    john.nguyen 25 on at
    RE: Error when copy User Settings

    Do we have any method that do not need to modify it by SQL Studio? Because the end-users have no skills to edit the SQL by this way! They can modify information on the GP screen only ...

    Best Regards,

    John Nguyen

  • Verified answer
    RE: Error when copy User Settings

    I'd take a look at this, if you haven't already found it:

    docs.microsoft.com/.../error-grant-user-access-test-company

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,532 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,501 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans