February 12, 2009 at 1:45 pm
I have created a set of scheduled jobs to restore production data into various copies of the database for Q/A personnel, and would like for Q/A personnel to be able to kick off those restore jobs on their own, without one of us DBAs having to do it for them. But if I make the Q/A team members of the serveradmin role, they will be able to wreak all sorts of havoc, whether intentional or not, so that's not really an option. I created an SSIS package witha SQL-authenticated account to connect to the server and kick off the desired restore job, but the package still connects to the server with their credentials rather than the SQL-authenticated account, so they still need to be serveradmin members to use the package. Any ideas on how to let non-serveradmins do scripted serveradmin-related tasks would be appreciated.
TIA,
- Matt Gauch
Kindest Regards,
Matt Gauch
February 13, 2009 at 6:21 am
Check out this entry in BOL: http://msdn.microsoft.com/en-us/library/ms187901.aspx
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply