tag:blogger.com,1999:blog-5285970135510371565.post3752877457721252207..comments2024-03-23T07:53:50.523-04:00Comments on The Dynamics GP Blogster: Smartlist Builder Security for SQL Server ViewsMariano Gomezhttp://www.blogger.com/profile/13267738662239812289noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-5285970135510371565.post-27092632430627026672008-12-09T18:48:00.000-05:002008-12-09T18:48:00.000-05:00Siva,Make sure you create the SQL view in all comp...Siva,<BR/><BR/>Make sure you create the SQL view in all company databases. Edit the XML file and change any reference to a non-existing database, to any of the databases currently available in your customer environment. This should work!<BR/><BR/>MG.-<BR/>Mariano Gomez, MVP<BR/>http://www.maximumglobalbusiness.comMariano Gomezhttps://www.blogger.com/profile/13267738662239812289noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-18874565242044465652008-12-09T03:10:00.000-05:002008-12-09T03:10:00.000-05:00Hi MarianoI am having the same permission issue wh...Hi Mariano<BR/>I am having the same permission issue when trying to import a SQL view based smartlist from another machine.<BR/>I have done all the steps mentioned by you and infact granted permissions for all SQL objects on TWO and DYNAMICS, but still get the error.<BR/>Any thoughts?<BR/><BR/>Regards<BR/>SivaKumarhttps://www.blogger.com/profile/12751913107077536512noreply@blogger.com