Showing posts with label sproc. Show all posts
Showing posts with label sproc. Show all posts

Wednesday, March 21, 2012

Permissions on stored procedures

Using Server Management Studio Express and SQL Server 2005 Express - is it possible to assign Exec permissions for users on a sproc by sproc basis. If so, how do I do this?

TIA

--
Mike BrindOk - I've found out how to do it. Just run a GRANT command in the Query Pane on the chosen procedure for the selected user.
sql

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 ?