DynDeveloper.com

DynDeveloper.com

Sign Up Now! Log In
sgray128 5/7/2014 10:23:32 AM

SQL Table Permissions Query

* This article, and all our great SQL (General) documentation, Is available on the SQL (General) menu

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.                       

Version: All
Section: Dynamics GP,SQL Scripts