Wednesday, March 7, 2012

Permission sql script

How can i find out which users have exec priviliges to a sproc using TSQL ?You could use sp_helprotect.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
What hardware is your SQL Server running on?
http://vyaskn.tripod.com/poll.htm
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:O2xFHt6VDHA.208@.tk2msftngp13.phx.gbl...
How can i find out which users have exec priviliges to a sproc using TSQL ?

No comments:

Post a Comment