necessary permissions to use maintenance plan except sysadmin

Question

_{Monday, July 18, 2016 7:08 AM}

Hi,

I need to give users the lowest level permissions to create or alter maintenance plan

and jobs.

All replies (4)

_{Monday, July 18, 2016 8:23 AM ✅Answered}

Object Explorer only displays the Maintenance Plans node for users who are members of the sysadmin fixed server role.

Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

MS SQL optimization: MS SQL Development and Optimization
MS SQL Consulting: Large scale of database and data cleansing
Remote DBA Services: Improves MS SQL Database Performance
SQL Server Integration Services: Business Intelligence

---

_{Monday, July 18, 2016 7:53 AM}

Greetings Arash,

it helps to add the SQL-version but i believe two grants should do the trick:

- ALTER TRACE

GRANT ALTER TRACE TO [@UserName]

- SQLAgentOperatorRole

EXECsp_addrolemember'SQLAgentOperatorRole', @userName

With kind regards,
Sebastian

---

_{Monday, July 18, 2016 8:25 AM}

Sorry my friend I made a mistake in the earlier post.

---

_{Monday, July 18, 2016 7:10 PM}

to be honest; for the sql maintenanceplan, I would need to google .
But knowing Uri, he is right.

I normally just role out Ola hallengren's maintenance :).