Admin Permissions

hi
need create new 'role' following permissions,

1. access sql server logs.
2. access maintenance plans ( can avoid access)
3. access activity monitor
4. normal access product databases , not system db´s

need guidance on how it, can point me in right direction please?

thanks

1.grant  execute on xp_readerrorlog [domainname\ad user or group];

2. http://technet.microsoft.com/en-us/library/ms191002.aspx

3.view server state permission

4. make user member of dbo_owner database role.

---

best regards,uri dimant sql server mvp, http://sqlblog.com/blogs/uri_dimant/

ms sql optimization: ms sql development , optimization
ms sql consulting: large scale of database , data cleansing
remote dba services: improves ms sql database performance
sql server integration services: business intelligence

SQL Server  >  SQL Server Security