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: Thursday, August 28, 2014 3:18 AM
Points: 127, Visits: 1,120
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
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 11:20 AM
Points: 1,980, Visits: 3,356
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