Tagged Questions
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;
...