Microsoft Dynamics GP (Archived)

How to Pull security task details each series wise

(0) Share

Report

Posted on by Arunsh

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

All responses (6)

Answers (0)

Arunsh 606 on at

Like (0)

Report

RE: How to Pull security task details each series wise

Thanks Leslie, I came across this query in victoriya Yudin but i missed SY09400 table with series. Thank you for the help.
Derek Albaugh on at

Like (0)

Report

RE: How to Pull security task details each series wise

My bad, I skipped right past those columns. Thanks again.
Suggested answer

L Vail 65,271 on at

Like (0)

Report

RE: How to Pull security task details each series wise

The Series assigned to the operations are in SY09400 TABLE

Kind regards,

Leslie
Derek Albaugh on at

Like (0)

Report

RE: How to Pull security task details each series wise

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.
Suggested answer

L Vail 65,271 on at

Like (0)

Report

RE: How to Pull security task details each series wise

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
Derek Albaugh on at

Like (0)

Report

RE: How to Pull security task details each series wise

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