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 |
|
cfair_ssis
Starting Member
6 Posts |
 Posted - 2010-10-05 : 09:56:46
|
| I'm trying to determine what users have the ability to execute a specific stored procedure. Can anyone provide me with a query that will return the login names of users that have the right to execute a specific stored procedure?Thanks,Chuck |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2010-10-05 : 10:31:44
|
| Try EXEC sp_helprotect 'myProcedure' |
 |
|
|
cfair_ssis
Starting Member
6 Posts |
Posted - 2010-10-05 : 11:00:39
|
| That's exactly what I needed.Thank you very much! |
|
|
|
|
|
|
Query to determine what users can execute a sproc