Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
DynDeveloper.com

DynDeveloper.com

Sign Up Now!Log In
kkoehle@valuedrugco.com 6/14/2018 11:37:11 AM

Permissions on SQL views in Smartlist Builder

I keep running into a brick wall on this topic.

We have several Smartlists that were created in Smartlist Builder.

This one in particular is looking at a View of our Inventory Items in GP.     It is a custom SQL table view.

A user can see this Smartlist but when he runs it, no records are found.

I have checked that the Smartlist Object is showing in the Security tasks list, and the user has permissions to view Inventory items.

Why is he blocked from seeing the contents of the View unless I make him 'sa' ?   (Not the answer, obviously.)

 

 

Version: GP 2015
Section: Dynamics GP








Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables