Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel Security
Message
From
27/12/2017 07:33:04
 
 
To
26/12/2017 16:13:44
General information
Forum:
Microsoft SQL Server
Category:
Business Intelligence
Title:
Miscellaneous
Thread ID:
01656740
Message ID:
01656755
Views:
50
>I'd like to give certain people in the organization the ability to query SQL Server tables in Excel
>
>However, I notice that when creating connections, the user can enter SQL Queries and from what I can see, those queries can alter data.
>In this installation, all Windows users of necessity have read/write access to SQL Server data
>Is there some way to restrict the Excel user to read only access?

sounds like they need more fine grained access rights/groups.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform