1,616
What are the steps to give access to a Smartlist Designer Object to and end user. Right now the end user can see the Smartlist Designer object, but when they click on it, they get no results. If 'sa' runs the object they do see results.
Thank you!
*This post is locked for comments
Hello Lisa!
To Expand on Mahmoud's answer you can run the grant script against the company DB if the Smartlist Designer object contains a view and DYNGRP has not been given the needed access.
You can find the Grant script on any machine with GP installed. GP Root Folder\SQL\Util\Grant.
If it is using a view and that does not resolve the issue you will also want to run a dex log and see if you find anything like the following in the log.
850996 - How to create a Dexsql.log file for Microsoft Dynamics GP support.microsoft.com/.../850996
The EXECUTE permission was denied on the object 'DYN_FUNC_Boolean_All', database 'somedatabase', schema 'dbo'.
The key in the above is that execute permission was denied on a function which is a quality issue that can occur with custom views and GP in certain versions and situations (Quality Issue #66949). If your using a custom view, the grant script does not resolve the issue, and you see something along the lines of the above in a Dexlog (execute permissions error against a function) you will want to open up a case with MS and they will be able to provide a script that will go through and grant the needed security to all the functions in one swoop.
Joshua
Hello Lisa
Since the user sees the smart list object, I believe that the user has been granted the required access on this specific smart list object.
Does this customized smart list retrieve data from an SQL view ? If so, you will need to run the following statement in order to grant the DYNGRP an access on the SQL object
GRANT SELECT ON #View_Name TO DYNGRP
Your feedback is highly appreciated,
#1
Almas Mahfooz
3
User Group Leader
Share
Report
All responses (
Answers (
