Andrew Crofts
asked on
User to run a stored procedure
MS SQL 2005/2008
Is there a simple way to allow a user to run a predefined stored procedure when they need to without allowing any other interaction with the database.
TIA
Is there a simple way to allow a user to run a predefined stored procedure when they need to without allowing any other interaction with the database.
TIA
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Of course you will need to have created the stored proc not with the default of EXECUTE AS CALLER. Instead, using EXECUTE AS 'other_user_name' would be easiest, to give the proc sufficient authority without giving it to the calling user.
ASKER
I was thinking more in terms of a front end rather than using Query analyser/SSMS as the users are not technical.
Just a select and click sort of solution.
I could write one myself I guess but wanted to avoid reinventing the wheel.
Just a select and click sort of solution.
I could write one myself I guess but wanted to avoid reinventing the wheel.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for your suggestions.
I have decided to do a dotnet console app and if I had decide that to begin with I'd have it implemented by now :-)
I have decided to do a dotnet console app and if I had decide that to begin with I'd have it implemented by now :-)