Dynamics GP Security Script

So if you work with Dynamics GP in any form of administrative role you understand the cost associated with a user license for your company.  So what I like to do is for routine task in Dynamics is to either create a SSRS item or use a SQL script to gather information.

One of the task I often get asked is who has what security roles inside of Dynamics GP.  So instead of logging into GP and drilling down through the embedded reports  or going user by user in the security setup window this script will display that information.   I will be releasing another file soon that can be tied to an existing SSRS deployment so you can run it as a report and then I’m going to build a version that plugs in as a custom report for SSMS.  I just haven’t had time to really set down and build the yet!

One last note is that this must be run against the DYNAMICS database.  Since GP 2013 allows the use of any name for the DYNAMICS database I didn’t bother to include the          USE DATABASE part of the script.

GP Security Role Assignment –  This will take you to the source of the script.


Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.