I have a little application which allows a user to execute a store procedure with a database restore command in it.
The user has to enter a user name and password but I have to give them higher rights than I would like too. Can I restrict this user to only being able to execute this SP?
Many thanks