Giving Access to Smartlist objects in Non – GP Databases

Giving Access to Smartlist objects in Non – GP Databases

Recently I was asked to create a SmartList for a table that was in a none Dynamics GP database. I logged into the SQL Server Management Studio as sa and created a view of the table in each of the GP Company databases. Then I logged into GP and created a SmartList of the view, set security, ran the GP grant.sql script against the company databases. I tested the view as the ‘sa’ user and it worked well but when I logged in as any other user I could see the SmartList but it returned no data. To fix the issue I had to give the DYNGROUP read/select access to the physical table.