We are trying to greatly reduce our use of the PowerUser Security Role. For installing new instances of GP, our HelpDesk uses our main PowerUser Role. Is there a way we could create individual UserIDs for the HelpDesk that would give them only the needed rights for installing GP on a machine, without the ability to access any of the business functions, add/edit/delete users, add/edit/delete Security Roles and Tasks? If so, what Tasks would this Role need access to?
Thanks
—————————— Robert Nash PharMEDium Services, LLC Lake Forest IL ——————————
“Any member of the SysAdmin fixed server role can upgrade from a previous release or install Microsoft Dynamics GP. The SysAdmin fixed server role should be granted by the SQL Server administrator to a GP user on an as needed basis, and should be revoked after the task is complete.”
The article explains in some detail steps you can take to limit the use of sa, and to properly separate functions to provide a safer control environment.
—————————— Bill Schulz Turnkey Technologies, Inc. St. Louis MO ————————————————————————-
Beat Bucher
Member
January 6, 2017 at 1:17 PM
Hi Robert,
Agree with Bill.. none of my IT folks that do GP Help desk support have a POWERUSER role assigned.. I created a basic IT_HelpDesk role with just the required bare minimum access to manage users in GP, so they can reset passwords, create new users, etc.. Nothing else.
All their GP account needs is the SQL server security role for ‘securityadmin’. that’s it.
—————————— Beat Bucher Business Analyst, Dynamics GP MVP Ultra-Electronics Forensic Technology Inc. Montreal QC/Canada +1-514-489-4267 @GP_Beat http://dyngpbeat.wordpress.com/ Montreal QC GPUG Chapter Leader GP2013R2 / MR2012 CU14 ————————————————————————-
Please note:
This action will also remove this member from your connections and send a report to the site admin.
Please allow a few minutes for this process to complete.
Report
You have already reported this .
Welcome to our new site!
Here you will find a wealth of information created for peopleĀ that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!