This is related to : https://sourceforge.net/p/smsclictr/support-requests/19/
Please excuse my ignorance as I have zero SQL server experience.
I have a user who is unable to view any of the adverts when using the 'Import policy' function. He is also unable to view any collections using 'Collection Commander'.
I have taken a look at the rights in SQL as you mention, but I can't see any way to grant read access to :
Read access to the Views: v_package, v_Advertisement
Read access to the Table: Policy
first off, there is table, schema, database and server permissions - also none of them have a 'read' option available.
So can you confirm which type of permission needs to be granted, and then which specific permission.
For instance, the user in question is a member of the group 'SMS Admins' and in the 'Database Properties' of the table 'dbo.policy', the group has been granted the 'connect' permission.
Any help greatly received :)