/
Smartlist Security

CINCH Customer Documentation

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:

  1. Go to Tools > Smartlist Builder > Security > SQL Table Security.

  2. Enter your system password.

  3. Select your database on the left.

  4. 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.]

image-20240320-132513.png

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.

Related content

SmartList Builder Table Finder
SmartList Builder Table Finder
More like this
Smartlist Repository
Smartlist Repository
More like this
Chapter 6_Limited User 12.2
Chapter 6_Limited User 12.2
More like this
User Security Settings - AGRIS Warehouse App
User Security Settings - AGRIS Warehouse App
More like this
Never have to rebuild a Smartlist
Never have to rebuild a Smartlist
More like this
Create Smartlist Favorite
Create Smartlist Favorite
More like this

3820 Mansell Road, Suite 350 ✦ Alpharetta, GA 30022 ✦ www.GreenstoneSystems.com
© 2013 - 2024 Cultura Technologies, LLC. All Rights Reserved Worldwide.  Products and company names mentioned herein may be trademarks or registered trademarks of their respective owners.