Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Suggested answer

Cannot alter the role DYNGRP

Posted on by 5

Getting the IMG_2D00_20210305_2D00_WA0017.jpegerror when installing web services

Categories:
  • Suggested answer
    Sookhapu Profile Picture
    Sookhapu 5 on at
    RE: Cannot alter the role DYNGRP

    All,

    Thanks for the suggestions. I figured out the issue, I was doing a migration and I forgot to restore one of the DBs, which resulted in this error. Once I restored the DB, it worked fine.

    Thanks Much

  • Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: Cannot alter the role DYNGRP

    Thanks for the clarification on that Derek.  

  • Suggested answer
    RE: Cannot alter the role DYNGRP

    I was more answering from not having the DYNGRP database role at all, but you're correct in that we normally don't want to be manually changing the core security objects like DYNGRP at all.

    During the install of Web Services, it does put objects such as tables, views and stored procedures into the GP databases and thus needs to add those permissions to DYNGRP, which is what I'm thinking it does when the above error shows.

    Nothing we commonly see when installing Web Services.

    Thanks

  • Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: Cannot alter the role DYNGRP

    I was wondering before answering - Why do you need / want to change the role of a Core Dynamics security object?  Maybe I am not asking with the right words - but I am thinking that out of the box the Role is created and defined - and there is a reason that all users are add to the group.

    Just me being curious.

  • Suggested answer
    RE: Cannot alter the role DYNGRP

    In SQL, if you look under Security > Roles > Database Roles, under each GP system and company database, do you see the DYNGRP database role present?

    If not, you can use a script like this to create it:

       CREATE ROLE [DYNGRP]

    Then, run the Grant.sql script for Dynamics GP against it, on all GP databases, which will give it the SELECT, INSERT, UPDATE and DELETE permissions for the GP tables and views, and EXECUTE permissions for stored procedures.

    Thanks

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,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans