Finance | Project Operations, Human Resources, ...

Dynamics GP Navigation Lists Security

(0) Share

Report

Posted on by PARevereGroup

Hello, Does anyone knows how to query in SQL all security task IDs that has access to a certain Navigation Lists like Sales Order Transactions Navigation List.

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Jeff Grant on at

Like (0)

Report

RE: Dynamics GP Navigation Lists Security

Hello,

Generally, following 'Resolution 4' of the following KB logged in as a user without permission to the window should help you trace back to the exact table permission needed to view the Navigation display: support.microsoft.com/.../EN-US

Best Regards,

Jeff Grant

Microsoft Dynamics GP Support

Was this reply helpful? Yes No
PARevereGroup 90 on at

Like (0)

Report

RE: Dynamics GP Navigation Lists Security

We tried this script below as part of the Resolution 4. We are not getting any results, but we know its part of Security Task ID TRX_SALES_001 using the Security Task Setup window. We need to know what other Security Task ID has it, without opening them one by one in the window.

SELECT ISNULL(A.SECURITYROLEID,'') AS SECURITYROLEID,

ISNULL(M.SECURITYROLENAME,'') AS SECURITYROLENAME,

--ISNULL(M.SECURITYROLEDESC,'') AS SECURITYROLEDESC,

ISNULL(O.SECURITYTASKID,'') AS SECURITYTASKID,

ISNULL(T.SECURITYTASKNAME,'') AS SECURITYTASKNAME,

--ISNULL(T.SECURITYTASKDESC,'') AS SECURITYTASKDESC,

R.PRODNAME, R.TYPESTR, R.DSPLNAME, R.RESTECHNAME, R.DICTID, R.SECRESTYPE,

R.SECURITYID FROM DYNAMICS.dbo.SY09400 R

FULL JOIN DYNAMICS.dbo.SY10700 O ON R.DICTID = O.DICTID AND O.SECRESTYPE = R.SECRESTYPE AND O.SECURITYID = R.SECURITYID

FULL JOIN DYNAMICS.dbo.SY09000 T ON T.SECURITYTASKID = O.SECURITYTASKID

FULL JOIN DYNAMICS.dbo.SY10600 A ON A.SECURITYTASKID = T.SECURITYTASKID

FULL JOIN DYNAMICS.dbo.SY09100 M ON M.SECURITYROLEID = A.SECURITYROLEID WHERE R.DSPLNAME = 'Sales Order Transactions'

Was this reply helpful? Yes No
Suggested answer

Lucas Boewood on at

Like (0)

Report

RE: Dynamics GP Navigation Lists Security

Hello!

I think you're getting no results because there isn't a window or report with that specific display name. Try querying just the SY10600 (Security Assignment Role Task)
table on the DYNAMICS database for that Security Task ID.

select * from SY10600 where SECURITYTASKID in ('TRX_SALES_001*')

I hope that helps!

Was this reply helpful? Yes No