Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel Security
Message
From
26/12/2017 16:13:44
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Business Intelligence
Title:
Excel Security
Miscellaneous
Thread ID:
01656740
Message ID:
01656740
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?
Anyone who does not go overboard- deserves to.
Malcolm Forbes, Sr.
Next
Reply
Map
View

Click here to load this message in the networking platform