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 |
|
tbrothers
Yak Posting Veteran
83 Posts |
 Posted - 2008-09-17 : 14:26:20
|
| SQL 2005 EntWe use Microsoft Great Plains Dynamics which has 15,101 stored procedures. Is there a way to select a single stored procedure and see who has Execute permissions?We're going through an audit and the auditors want to spot check.Thanks,Terry |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-09-17 : 14:37:45
|
| Yes.sp_helprotect 'YourSP'--all permission in this SPsp_helprotect Null,'Loginname'--ALl object level permission of that loginname. |
 |
|
|
tbrothers
Yak Posting Veteran
83 Posts |
Posted - 2008-09-17 : 14:38:53
|
| Thanks |
|
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2008-09-17 : 14:40:15
|
| Or if you prefer:From Management Studio - Object Exploreryou can navigate to an SP, Right click to view Properties, Permissions page.Be One with the OptimizerTG |
|
|
|
tbrothers
Yak Posting Veteran
83 Posts |
Posted - 2008-09-17 : 14:46:32
|
| That doesn't work for System SP's. When I right-click I only have the modify option.Terry |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-09-17 : 14:50:32
|
| No need for system sp.All users in Public will have permissions to it. |
|
|
|
|
|
|
Execute Permission