Limited Users in Dynamics GP 2013 R2 – Security Insight

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.

 

 

 

USE DYNAMICS
SELECT  RTRIM(PRODNAME) ProductName ,
        RTRIM(TYPESTR) Type ,
        RTRIM(Series_Name) AS Series ,
        RTRIM(DSPLNAME) DisplayName ,
        RESTECHNAME AS Resource_Technical_Name,
        CASE AvailLmtdUsrs
           WHEN 1 THEN 'Yes'
           ELSE 'No'
        END AS AvailableToLimitedUser
        --  SECRESTYPE SecurityResourceType,
        --     DICTID AS DictionaryID,
        --  SECURITYID SecyrityID ,
FROM    SY09400
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

Best Regards,
Mahmoud M. AlSaadi