granting non sysadmin user pause/resume permission on mirroring

• egpotus

  SSCommitted

  Points: 1654

  More actions

  June 18, 2014 at 4:10 am

  #292506

  hi,

  Did someone know if it is possible to grant a non sysadmin user permission to pause & resume mirroring ?

  regards

  eric

  FYI the following can only grant me "view" access

  USE [msdb]

  GO

  EXEC sp_addrolemember N'dbm_monitor', N'MyNonSysadminuser'

  ---

  Kindest Regards,

  egpotus DBA
  

• Gazareth

  One Orange Chip

  Points: 27737

  More actions

  June 18, 2014 at 4:26 am

  #1722678

  I think the ALTER DATABASE right will be enough; they'll be able to do a lot more than just pause/resume mirroring though!