We are trying to accomplish the following:
1. Restricted user rights
2. Have a stored procedure on which the user has execute rights
3. Have the stored procedure run with sa rights
How do we give the procedure increased rights over what the user has?
The procedure needs to be able to restore a database.
Please help! Thanks ahead of time!
-Stephen
Carpe Codum.