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 |
|
boyeneye
Starting Member
3 Posts |
 Posted - 2011-02-01 : 07:12:33
|
| Please, i have a list of some System Sored procedure and i need to know users/logins that have execute access to these stored prcodeures.Is there any sql command that i can run to determine users that have execute right on the listed Stored Procedure?xp_available media xp_dirtree xp_dsninfo xp_enumdsn xp_enumerrorlogs xp_enumgroups xp_eventlog xp_fixeddrives |
|
|
DaleTurley
Yak Posting Veteran
76 Posts |
Posted - 2011-02-01 : 08:29:25
|
| Use this catalog view to determine direct permissionssys.database_permissions. |
 |
|
|
|
|
|
System Stored Procedure Access Right