Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

#54 Unable to view 'Import Policy' list

v1.0 (example)
open
nobody
5
2014-02-28
2014-02-21
Gareth Hope
No

Hi,

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 :)

Gareth.

Discussion

  • Roger
    Roger
    2014-02-28

    'Read Access' = 'SELECT' rights... And of course you need also the right to connect SQL.