I'm installing the EOne product SmartList Builder and it's not working quite right, and I suspect a SQL permission issue. Normally tables in Dynamics have permissions granted to the DYNGRP user
I checked a table or two, and yep, no permissions. So I sat down to write a SQL query that would show all tables in the database with no permissions.
Then, I wrote a script to add the needed perms to the tables.
Both queries are below.
Enjoy.