AFAIK, you cannot assing rights to stored procedure.
>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
--sb--