colinmitton
Technical User
I need to set up a user to have limited access to my SQL 2008 R2 server, they only need to access 2 maintenance plans so they can run ad-hoc backups on two different databases.
Sadly my SQL knowledge runs back to MS-SQL 2000 and I now have about a 10 year gap in my knowledge! Can I set up a user to only have access to maintenance plans and at that point only 2 of the plans that I have set up (I have about 15 in total!)
I will want them to RDP to the server, I'll then put SSMS in the startup folder to direct them to that program and then have only access to the 'Jobs' in the SQL Server Agent area nothing else. Or is there an easier way?
Thanks
Sadly my SQL knowledge runs back to MS-SQL 2000 and I now have about a 10 year gap in my knowledge! Can I set up a user to only have access to maintenance plans and at that point only 2 of the plans that I have set up (I have about 15 in total!)
I will want them to RDP to the server, I'll then put SSMS in the startup folder to direct them to that program and then have only access to the 'Jobs' in the SQL Server Agent area nothing else. Or is there an easier way?
Thanks
