I have a poweruser who builds Smartlist reports but she does not have access 
to SQL.  When she creates a new report using an existing View, the user 
always gets a blank Smartlist report (exploring...completed... no records).

We followed the advice to mark all tables and views in SmartList builder 
security but that never seems to do the trick.

I am running grant.sql on all our companies now. 

Does she have to come to me to run the script every time she has a new 
report? Why doesn't the Smartlist Security option add DYNGRP to the view 
security?

thanks

Because Smartlist Builder can not assume that all views you create in SQL 
Server are going to be used specifically to create a Smartlist. So, you will 
need to grant permissions to DYNGRP to any new/custom view when created.

By the way, it's not necessary always to run the GRANT.SQL script. You can 
simple type the statement in a query window:

GRANT SELECT, INSERT, UPDATE, DELETE ON dbo.FooView TO DYNGRP;

This will save you considerable amount of time.
-- 
Best regards,
--
MG.-
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
http://www.maximumglobalbusiness.com
The Dynamics GP Blogster at http://dynamicsgpblogster.blogspot.com


"barbola" wrote:

> I have a poweruser who builds Smartlist reports but she does not have access 
> to SQL.  When she creates a new report using an existing View, the user 
> always gets a blank Smartlist report (exploring...completed... no records).
> 
> We followed the advice to mark all tables and views in SmartList builder 
> security but that never seems to do the trick.
> 
> I am running grant.sql on all our companies now. 
> 
> Does she have to come to me to run the script every time she has a new 
> report? Why doesn't the Smartlist Security option add DYNGRP to the view 
> security?
> 
> thanks