You’re offline. This is a read only version of the page.
606
Hi All,
Hope everyone good. Its been a long time coming to community asking questions.
I have a question related to security tasks in GP.
I need data of security tasks each series wise. Like
In Inventory series what are the security tasks associated with it.
Financial Series Security tasks.
I searched almost everywhere but couldn't find query or solution. If you guys can share on this it would be really helpful.
Regards,
*This post is locked for comments
My bad, I skipped right past those columns. Thanks again.
I think this is about as close as we'd be able to get as it returns the list of security roles, security tasks, task names and security task description for each user and each company database. The only thing missing is that none of the tables have a 'Series' column so we can't divide it by series, such as Financial, Inventory, Purchasing, etc.
Thanks Leslie.
This view from Victoria Yudin's web site will provide the information I think you need.
Kind regards,
Leslie
CREATE VIEW view_Security_Roles_and_Tasks
AS
/**
view_Security_Roles_and_Tasks
Created Mar 12 2009 by Victoria Yudin - Flexible Solutions, Inc.
For updates see victoriayudin.com/gp-reports
Shows all security roles and tasks by user by company
**/
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
/** the following will grant permissions to this view to DYNGRP,
leave this section off if you do not want to grant permissions **/
GO
GRANT SELECT ON view_Security_Roles_and_Tasks TO DYNGRP
There is a 'Security Task Setup Report' which will show you all security operations the security task gives access to, by Type, Security Operation, Series and Dictionary.
There is also a 'Security operation Access Report' which will show you which users are assigned/have access to a specific security operation.
Both of these reports can be accessed and ran from the Security Task Setup window. (Administration > Setup > System > Security Tasks).
In your case, you could choose a security task under Financial, such as 'ADMIN_FIN_001*', then run the Security Task Setup Report, which will show which operations this task gives access to.
Unfortunately, with this report, there isn't a way to select multiple security tasks or all security tasks under a specific series, like Financial or Inventory.
The SY10700 table doesn't differentiate by series, only DICTID, so there's not any way to use a SQL view or script to get a better form of this type of report either.
Let me know if you have any questions on the above.
Thanks
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,188
Super User 2024 Season 2
#2
Martin Dráb
230,030
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (