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,
bj
*This post is locked for comments
Please never hesitate to share any further inquiries.
Thank you for taking the time.
Your assistance is greatly appreciated,
bj
Do you guys have customizations? If yes it would be little complex for you.
Find the list below;
In order to limit down your options, find the references below for all dynamics gp 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,
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!!!
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (