var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Permissions for Database Mirroring
I am using SQL 2008 R2 Standard Edition. The Mirroring is working fine for the Database between 2 SQL Servers.
What permissions can I give to the Application User so the he can see the Mirroring Details under properties when you right click the Database ? I am trying to avoid giving sysadmin.
The permissions for Database Mirroring monitor was dbm_monitor role in msdb. Once I gave that, the user is able to access the Database Mirroring Monitor but he still can't see the Mirroring Details under properties of the Database.
Any help will be appreciated.
Can any SQL Guru who can help on this one ?
Try granting select permissions on sys.database_mirroring. Alternatively, you could grant VIEW SERVER STATE, but that is going to bring a lot more baggage along.
1) Select permission on sys.database_mirroring in master doesnt help.
2) Even VIEW SERVER STATE doesnt help.
The only thing which has worked so far is giving dbo access to Master. Its better than sysadmin but will still try to lower the permissions further.
There are several db mirroring views in master. Do a search for things with mirror in the name, and you should get a list of things to try narrowing the permissions to.
where name like '%mirror%'
Thanks for the input. I gave blanket db_datareader on master. That didnt help. So it doesn't make sense to try for the individual sys tables in master.
Last edited by mgupta; 07-11-11 at
One other thing you can do is run a trace for the permission errors. Those should give you not only the objects involved, but the required permissions.
As normal with SSMS, it touches a lot of objects. Our list for database mirroring properties is:
Happy hunting, and be careful
thanks to Roac and Mcrowley for all the Help !!!