Direct Me to Tables for Assigning Role For User Security

(0) Share

Report

Posted on by Community Member

I am setting-up roles in 2013 Dynamics GP, so I can deploy user security. Please assist me by telling me how to get to the right tables and make the role assignments. Thanks,

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (2)

Suggested answer

soma 24,410 on at

Like (0)

Report

SY10500 -- User role assignment

SY10600 -- Task and role assignment

SY09000 -- Task Master

SY10700 -- Operation in Task

SY09400 -- Resource description (This table contains values after processing the clear table in GP-->Maintenance-->Clear Data ) The values for this table have the operation in task along with resource name.

Hope this helps!!!

Was this reply helpful? Yes No
Verified answer

Mahmoud Saadi 32,738 on at

Like (0)

Report
Find the list below;

In order to limit down your options, find the references below for all dynamics gp tables;

Dynamics GP Table reference

MVP Mark Polino reference of Dynamics GP Tables

On your Dynamics GP: Tools > Resource Description > Tables

In addition, if you are thinking about scripting out some data from the security tables, you could consider the following SQL view as a start;

SELECT SR.CMPNYNAM AS 'Company Name',
        USERID AS 'GP User ID',
        ST.SECURITYROLEID AS 'Security Role ID',
        ST.SECURITYTASKID AS 'Security Task ID',
        ST.SECURITYTASKNAME AS 'Security Task Name' ,
        ST.SECURITYTASKDESC AS 'Security Task Description'
FROM    ( SELECT    [CMPNYNAM] ,
                    [USERID] ,
                    [SECURITYROLEID]
          FROM      [SY10500] AS A
                    INNER JOIN [SY01500] AS B ON A.[CMPANYID] = B.[CMPANYID]
        ) AS SR
        LEFT OUTER JOIN
        ( SELECT    C.[SECURITYROLEID] ,
                    C.[SECURITYTASKID] ,
                    D.[SECURITYTASKNAME] ,
                    D.[SECURITYTASKDESC]
          FROM      [SY10600] AS C
          INNER JOIN [SY09000] AS D ON C.[SECURITYTASKID] = D.[SECURITYTASKID]
         ) AS ST ON ST.SECURITYROLEID = SR.SECURITYROLEID

Further illustration on the script above can be found on the link below;

User Security Role Enhancement–Intersect

Hope this helps,

Was this reply helpful? Yes No
Almas Mahfooz 11,009 User Group Leader on at

Like (0)

Report

Do you guys have customizations? If yes it would be little complex for you.

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

Thank you for taking the time.

Your assistance is greatly appreciated,

bj

Was this reply helpful? Yes No
Mahmoud Saadi 32,738 on at

Like (0)

Report

Please never hesitate to share any further inquiries.

Was this reply helpful? Yes No