A very common issue that has been seen recently with among Dynamics GP client is the access of the limited user, you always encounter a simple question and proceed with several clicks and checks to reach an answer or “Yes it has access or No it doesn’t have an access” on this specific window.
It is worth saying that the answer is just there at the tips of your fingers. When opening the security task window, a new icon has been added to “denote windows available to limited user types”. See below:
Security Task Details as Related to Limited User – SQL View
The script below retrieves all the security task details as related to whether a limited user has an the access or not. This will definitely help you while building customized security roles for your limited users.
SELECT RTRIM(PRODNAME) ProductName ,
RTRIM(TYPESTR) Type ,
RTRIM(Series_Name) AS Series ,
RTRIM(DSPLNAME) DisplayName ,
RESTECHNAME AS Resource_Technical_Name,
WHEN 1 THEN 'Yes'
END AS AvailableToLimitedUser
-- SECRESTYPE SecurityResourceType,
-- DICTID AS DictionaryID,
-- SECURITYID SecyrityID ,
ORDER BY 1,2,3,4
Security Resource Description – Excel Report
In order to have the maximum benefit of the script above, you can drop it into Excel and have a pivot table report, as shown below:
Here is the filter to consider:
Here is the Pivot Report:
You can download the Security Resource Excel report from Here
Mahmoud M. AlSaadi