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 |
|
Sprinjee
Starting Member
42 Posts |
 Posted - 2006-05-03 : 04:46:54
|
| Can someone help me out. What is best practice to give a specific user the right to execute a specific stored procedure? |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-05-03 : 05:24:01
|
| you mean criteria to determine if a user should have exec rights?that depends if the user really needs to execute the sprocor am i over simplifying this?--------------------keeping it simple... |
 |
|
|
Sprinjee
Starting Member
42 Posts |
Posted - 2006-05-03 : 05:32:17
|
| Never mind found it. Using the Ent. manager I was able to assign exec permission for this procedure to a databaserole. |
|
|
|
|
|
|
EXEC rights