You’re offline. This is a read only version of the page.
245
Our auditors have requested a list of permissions each user (or role, it doesn't really matter) each user has in GP 10. Last year during our audit, we were running GP 8, which had a User Classes report that showed the detailed permissions for each user class.
It seems that in GP 10, the User Classes report doesn't show any information about permissions at all. It's just a simple listing of the classes.
What report could I use in GP 10 to show detailed information about user/role permissions?
*This post is locked for comments
I created a smartlist in SmartList Builder so I would have for our auditors in the future. It's exactly the same script as Donnette.
Display SQL from within SmartList Builder:
select *
from DYNAMICS..SY10500 T1 with (nolock)
INNER JOIN DYNAMICS..SY01500 T2 with (nolock)
on
T2.[CMPANYID] = T1.[CMPANYID]
LEFT JOIN DYNAMICS..SY10600 T3 with (nolock)
on
T3.[SECURITYROLEID] = T1.[SECURITYROLEID]
LEFT JOIN DYNAMICS..SY09000 T4 with (nolock)
on
T4.[SECURITYTASKID] = T3.[SECURITYTASKID]
Here's a SQL srcipt to find user security roles and tasks:
Use DYNAMICS
SELECT S.USERID UserID, S.CMPANYID CompanyID,
C.CMPNYNAM CompanyName, S.SecurityRoleID,
coalesce(T.SECURITYTASKID,'') SecurityTaskID,
coalesce(TM.SECURITYTASKNAME,'') SecurityTaskName,
coalesce(TM.SECURITYTASKDESC,'') SecurityTaskDescription
FROM SY10500 S -- security assignment user role
LEFT OUTER JOIN
SY01500 C -- company master
ON S.CMPANYID = C.CMPANYID
LEFT OUTER JOIN
SY10600 T -- tasks in roles
ON S.SECURITYROLEID = T.SECURITYROLEID
LEFT OUTER JOIN
SY09000 TM -- tasks master
ON T.SECURITYTASKID = TM.SECURITYTASKID
Under Administration > Reports > Security, you have several reports detailing security settings in the system. You're probably after the User Security report as it details assigned Security Role, Security Tasks, and Task Descriptions. This is still a fairly high level report and you may want to explore the Security Task Setup Report (access detailed below).
This works well if you are not using the CNV converted security though as this will likely lump everthing together. If you are using the CNV converted security (or need additonal detail), you will need to go into each CNV Security Task and click the print button to generate the Security Task Setup Report. This gets pretty granular and is reporting on individual access points within the system.
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,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (