Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
exxoid
Starting Member
5 Posts |
 Posted - 2009-04-20 : 16:56:47
|
| How would I create a user that only has access to execute a specific stored procedure and nothing else?This user is going to be a SQL User, and not tied through any Active Directory user.Thanks for your help. |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2009-04-20 : 17:16:35
|
| Not sure what specific step you are having problems doing but basically, either with t-sql code or interactively through management studio, create the (server) login then create the (database) user from that login. Now at this point the user should be there with no permissions at all. Then you can grant EXECUTE permission on your stored procedure to your user.If you need more help specify if you want to do this using t-sql code or interactively through management studio.Be One with the OptimizerTG |
 |
|
|
svicky9
Posting Yak Master
232 Posts |
|
|
|
|
|
Create a user with only execute permission to a SP