A common request we receive is: “We want to tie down security of our users but have no clue as to who has access to what”. To be frank, the reporting for this in GP is not exactly easy to come by. While there are a number of ISVs available that will provide you with tools and analytics for this information, we have a quick fan-favorite solution via SQL to gather this data.
This information can also be found on the Microsoft Developer Blog here.
First thing’s first, in order to get the following script to populate data, the Clear Data Procedure on the Security Resource Descriptions table within GP. This can be done from Microsoft Dynamics GP>>Maintenance>>Clear Data
Select ‘Display’ in the toolbar change to ‘Physical’, Series = ‘System’ & Table = Security Resource Descriptions.
Until Next Time!
