I have a collegue who want to get an access to one SQL Server 2008 instance. I'll have to give him rights to this instance. He should have rights to do is e.g.
- Add and modify server logins
- Add and modify maintenanace plans (e.g. create backups from the databases)
- Schedule Agent jobs
I don't want to give him sysadmin rights, what rights should be given?