Smartlist Security

Have you encountered the error message: "You do not have security privileges to view all of the tables used in this SmartList"?

If you're a power user or have been granted access through user security, the next step is for the system administrator to check the company table security.

To do this in Microsoft Dynamics GP:

Go to Tools > Smartlist Builder > Security > SQL Table Security.
Enter your system password.
Select your database on the left.
Choose the tables you wish to grant access for that company on the right. You can select tables or views.

[Note: Further security can be set up per user in user security using roles and tasks.]

Most of these should default to access when installed. However, if you create SmartLists using tables from a third-party product, it may not have defaulted to allow access to the third-party product tables.

Importantly, this does not alter your user security settings. A power user will still be able to use the SmartList, and only those with the correct user securities.

If you require assistance with this process or if it isn't working as expected, feel free to contact support at mysupport@culturatech.com.