Error message when you try to view a SmartList object in Microsoft Dynamics GP: "You do not have security privileges to view all of the tables used in this SmartList”

To resolve this problem, verify the following based on the version of Microsoft Dynamics GP that you are using:

• Verify that the user has the security privileges that are required to view the SQL tables in a SmartList.
• Verify that the user has access to the table that is used for the object.

Microsoft Dynamics GP 10.0/ Microsoft Dynamics GP 2010

Create a new security task. To do this, follow these steps:

1. On the Microsoft Dynamics GP menu, point to Tools, point to Setup, point to System, and then click Security Tasks.
2. In the Security Task Setup window, in the Task ID box, type a task identifier (ID).
3. In the Task Name box, type a task name.
4. In the Task Description box, type a description.
5. In the Category list, click System.
6. In the Product list, click SmartList Builder.
7. In the Type list, click SmartList Builder Permissions.
8. In the Series list, click SmartList Builder. The Access List area displays the various permissions for SmartList Builder.
9. Click to select the check box next to View SmartLists with SQL Tables.
10. Click Save.
11. Close the Security Task Setup window.

SmartList Builder Security

1. On the Microsoft Dynamics GP menu, point to Tools, point to SmartList Builder, point to Security, and then click SQL Table Security.
2. On the left side, click the check box next to the database name for which you are receiving the error.
3. On the right side, click the check box next to the table/view name that is used by the SmartList Item.
   
   Note You can also click Mark All to mark all the tables in the company database.

Microsoft Dynamics GP 9.0

1. On the Tools menu, point to SmartList Builder, point to Security, and then click User Security.
2. In the SmartList User Security window, click User Security.
3. In the User ID list, click the user who is receiving the error message that is mentioned in the "Symptoms" section.
4. In the Roles area, click to select the check box next to the View SmartLists with SQL Tablesoption.
5. If you are using user classes, click User Class Security, and then repeat step 4.
6. Click OK to save the changes.

SmartList Builder Security

1. On the Tools menu, point to SmartList Builder, point to Security, and then click SQL Table Security.
2. On the left side, click the check box next to the database name for which you are receiving the error.
3. On the right side, click the check box next to the table/view name that is used by the SmartList item.
   
   Note You can also click Mark All to mark all the tables in the company database.
4. Repeat step 2 and 3 for views if you have a view used in the SmartList Builder object.