How to define a user in MS SQL Server 2012 that can import data into Excel, but nothing more
I need to setup a user in SQL Server 2012 that can download data into Excel 2013 PowerPivot. It seems that it's not possible to completely hide the connection string in Excel, so it's important that the user has the absolute minimum of rights on the server instance and database as the Excel workbook will be shared. Would appreciate any good suggestions.
Microsoft SQL Server
8/22/2022 - Mon
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!