April 26, 2010 at 10:31 am
Hello,
I would like to grant a user the ability to run the copy database job only. I have it setup as a scheduled job but for testing purposes it would be better he was able to do this as needed. The copy is from a production database on a production server to a test database on a test server.
What permissions are required? Does he need sysadmin permissions (which would make this not feasible) on either one or both of the source or destination servers?
May 3, 2010 at 3:26 pm
Bump.
May 3, 2010 at 8:20 pm
According to MS,
http://msdn.microsoft.com/en-us/library/ms188664.aspx, you must be a member of the sysadmin role on both the source and the destination.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 4, 2010 at 3:35 pm
Thanks!
May 4, 2010 at 4:16 pm
You're welcome.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 5, 2010 at 4:43 am
CirquedeSQLeil (5/3/2010)
According to MS,http://msdn.microsoft.com/en-us/library/ms188664.aspx, you must be a member of the sysadmin role on both the source and the destination.
We have done this using credtials and some server roles. NOT sysadmin.
Adam Zacks-------------------------------------------Be Nice, Or Leave
May 5, 2010 at 9:01 am
Schadenfreude-Mei (5/5/2010)
CirquedeSQLeil (5/3/2010)
According to MS,http://msdn.microsoft.com/en-us/library/ms188664.aspx, you must be a member of the sysadmin role on both the source and the destination.
We have done this using credtials and some server roles. NOT sysadmin.
Could you explain what you did to get it to work? This would be good to take back to Microsoft.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 5, 2010 at 9:08 am
I created a USP that I gave execute permissions to a service account and then usinf a mixture of proxies and credentials gave the user access to execute the USP on their own.
Also go another solution which allows the user to execute a job (but that is to execute a ssis package) and not db restore.
Will play and upload script if i have time.
Adam Zacks-------------------------------------------Be Nice, Or Leave
May 5, 2010 at 9:50 am
Thanks
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply