• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 76
  • Last Modified:

Granting users in active domain permissions to execute a stored procedure from an excel workbook

I have created a workbook on a public drive accessible to about 5 users.  Within the workbook is a macro that runs a SQL 2008 R2 stored procedure to update a table within the workbook.  It works perfectly for my user access.  Currently these 5 users have read privileges to access views and tables within the SQL Server from Excel.

What are the procedures to set these users up to be able to execute the stored procedure?  I have seen a lot of different styles and advice on this matter.

Do I need to "alter" the SP grant them permissions?  Or do I need to get the DBA involved?

Let me know.

thanks

Glen
0
GPSPOW
Asked:
GPSPOW
1 Solution
 
LowfatspreadCommented:
i suggest that you involve your dba in the solution,,,

basically to let him know that you are intending this extensions of access to the data,,, so that he can

properly assess the impact from a security and performance viewpoint that fits in with your companies security and audit policies.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
You need to grant permissions for execute the SP:
GRANT EXECUTE ON SPName TO UserName
0
 
GPSPOWAuthor Commented:
I will try this and notify the user to test the report



Thanks

Glen
0
 
GPSPOWAuthor Commented:
No objections

Please close
0
 
Martin LissRetired ProgrammerCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now