I would like to give the db_creator server-role to a specific SP which can be used to create/refresh database snapshots. I do not want to grant the role to the login. Any ideas, or information how this can be done?
U can recreate the procedure with this option "With Execute as " (See Books Online) or u can use "Execute AS" See Books Online to execute the specific statements.
In this particular case i think u should use the With Execute AS option. Remember that the users will need execute permission to the sp or else it won't execute.
Hope it helps
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply