0
votes
3answers
3k views

How can I give a SQL Server user permission to run one stored procedure and nothing else?

I need to be able to remotely monitor the disk space on a SQL 2005 server. To do this I need to give a sql server user the ability to run the following stored procedure: EXEC xp_fixeddrives; ...