Microsoft Dynamics GP Application Level Security Series

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
For the next couple of weeks, I have decided to focus on Microsoft Dynamics GP application level security and methods for resolving security related issues.
Where possible I will also show how using the Support Debugging Tool for Microsoft Dynamics GP (now replaced by GP Power Tools) can make the process simpler and quicker.
The posts in the series include:
- 10-Nov-2008: How to transfer Security Tasks and Roles between Systems
- 12-Nov-2008: How to identify the Security Tasks and Security Roles associated with a specific window or report
- 14-Nov-2008: How to identify the Security Tasks and Security Roles using the Support Debugging Tool
- 17-Nov-2008: How to resolve Security errors on Login
- 19-Nov-2008: How to resolve Security Privileges errors
- 21-Nov-2008: How to resolve Dictionary not Loaded errors
- 24-Nov-2008: Information about using v10.0 Security Conversion Tool
- 16-Jun-2010: Users (other than ‘sa’) unable to login after upgrade
- 30-Aug-2010: Update: How to identify the Security Tasks and Security Roles using the Support Debugging Tool
- 16-Dec-2010: Solving Security Privileges Errors Using the Support Debugging Tool
- 27-Jun-2012: Security Settings are not working for a Company
Note: Links will be available on or after the posting date.
I hope you find the information in this series useful.
Please let me know if you have any security related questions that are not covered by these posts.
David
16-Jun-2010: Added link to another security related post.
30-Aug-2010: Added link to new post on identifying Security Tasks and Roles.
16-Dec-2010: Added link to post on using Support Debugging Tool to solve security errors.
27-Jun-2012: Added link to post on Security Settings are not working for a Company.
This article was originally posted on the Developing for Dynamics GP Blog and has been reposted on https://www.winthropdc.com/blog.

David Musgrave over at Developing for Dynamics GP is tackling Dynamics GP 10 Security in a new series
From the Microsoft Dynamics GP Application Level Security Series . With the change from the optimistic
From the Dynamics GP Blogster
http://dynamicsgpblogster.blogspot.com/2008/11/microsoft-dynamics-gp-10-security.html
From the Microsoft Dynamics GP Application Level Security Series . Microsoft Dynamics GP version 10.0
From the Microsoft Dynamics GP Application Level Security Series . In the previous post, How to identify
From the Microsoft Dynamics GP Application Level Security Series . When access is denied by the application
From the Microsoft Dynamics GP Application Level Security Series . When attempting to open a window you
From the Microsoft Dynamics GP Application Level Security Series . This is the final article in this
After the success of the Microsoft Dynamics GP Application Level Security Series , I have decided to
Based on the success of the "Resolving Security Issues in Dynamics GP" located here, Microsoft Dynamics
Based on the success of the "Resolving Security Issues in Dynamics GP" located here, Microsoft
Dynamics GP 10.0 has brought about a drastic change in GP security. Not only is the security pessimistic
Posting from the Dynamics GP Blogster
http://dynamicsgpblogster.blogspot.com/2009/04/microsoft-dynamics-gp-10-poweruser-role.html
Posting from Jivtesh Singh at About Dynamics, Development and Life
http://www.jivtesh.com/…/security-taskrole-associated-with.html
David
How can one get a report of all users that have access to anything in Payroll (the task category 'Payroll')? With Support Debugger Tool, it looks like you have to identify each window or report. There is a Security Task Assignment report in GP where you can restrict by task category, but it renders a blank report (not blank when by task ID).
Ideas?
Denni
Denni – Take a look at the article by MVP Victoria Yudin in the link below.
victoriayudin.com/…/sql-view-with-security-resource-details-for-dynamics-gp-10
Hope this helps.
Hi Denni and Siva
Try changing the view on the right pane of the Security Information window, you can then expand payroll tasks and roles and see who has access.
David
Hi David,
I know this post is quite old and has be revisited several times since then, but I'm still trying to find some useful information about the Account Level Security in GP… I've located the tables in the system DB (GLxxxxxFx and ORG10000), but no real report that shows you how many GL accounts are assigned to which level and which accounts doesn't have ACS assigned… Are you aware about anything existing for this ? Any documentation aside of the scarce one that comes with GP ?
Thanks for any hints
Beat