Share
ReportHello, 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.
You’re offline. This is a read only version of the page.
90
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.
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!
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'
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
#1
André Arnaud de Cal...
291,861
Super User 2024 Season 2
#2
Martin Dráb
230,540
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (
