Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

granting non sysadmin user pause/resume permission on mirroring Expand / Collapse
Author
Message
Posted Wednesday, June 18, 2014 4:10 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 9:07 AM
Points: 127, Visits: 1,125
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

Post #1582784
Posted Wednesday, June 18, 2014 4:26 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 11:49 AM
Points: 2,019, Visits: 3,469
I think the ALTER DATABASE right will be enough; they'll be able to do a lot more than just pause/resume mirroring though!
Post #1582791
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse