Granting Read Only Privilege on Maintenance Plan node.

• ArjunaReddy

  Default port

  Points: 1467

  More actions

  October 7, 2011 at 3:17 am

  #258644

  Hi - Do we have any role/privilege which will allow user to just view all the maintenance plans that are on a instance? I know sysadmin role allows user to create and manage Maintenance plans, but I want to limit user to just see the existing plans (no modify,edit or create privs).

  Thanks,

  Nagarjun.

• Geniiius

  Mr or Mrs. 500

  Points: 515

  More actions

  October 7, 2011 at 11:33 am

  #1391890

  The documentation (http://msdn.microsoft.com/en-us/library/ms187658%28v=SQL.100%29.aspx) states:

  "You must be a member of the sysadmin role to create and manage maintenance plans, and to view them in Object Explorer."

  So it does not seem to be possible to accomplish what you are looking for witout granting sysadm role.

  @HenrikSjang