You Do not have security Privileges to View all of the Tables used in this smartlist
Chip asked 3 months ago
I have Created a Custom View in SQL and added DYNGRP (Select) rights. The View only uses the POP10100 and POP10110
I have added the view to Smartlist with Smartlist Builder.
It works fine for power users, but I get the following error message for all other users.
You Do not have security Privileges to View all of the Tables used in this smartlist
Where do you add user access to these tables?
Patrick Roth Staff answered 4 weeks ago
Chip,
A little late as I’m sure you have your answer by now….
For this error it means that the user doesn’t have SmartList Builder table security to one or more objects on the report for this (current) database.
Since we _assume_ that this SQL View is the one that SLB is complaining about –
go to Tools | SmartList Builder | Security | SQL Table Security
pick the company database on the left and then flip to “views” on the right and find your sql view. Mark that view in the window or else use “mark all”
Now the user should be able to run the report.
patrick