I have a user on a database which cannot have database-level permissions assigned to it seeing that they are wiped periodically but the user needs to execute on certain stored procedures within said database so that he can import data properly.

What I am currently doing is running GRANT EXECUTE ON certain.storeProcedure TO user every time the permissions are wiped, but this isn't the most elegant solution.

However, server-level permissions are not wiped in the same way. There is the Alter Database permission, but that is too broad for my needs.

Also, I did find this site , but I cannot parse the tables within it.

So my question is: Is there a way to emulate the database-level EXECUTE permission using server-level permissions while being as restrictive as possible?