Granting Read-Only and administrative access to Central Management Server (CMS) | SansSQL

Monday, December 5, 2011

Granting Read-Only and administrative access to Central Management Server (CMS)

In one of my previous post, I had discussed about the Central Management Server and how to Register it.
In this post, I will be telling how to give read-only access and a Administrative access to an existing CMS.

Grating the Read-Only and Administrative access to CMS is very simply and the activity includes adding the right database users to right groups in msdb database.

Granting Read-Only access:
USE [msdb]
GO
CREATE USER [DBUserName] FOR LOGIN [LoginName]
GO
EXEC sp_addrolemember N'ServerGroupReaderRole', N'DBUserName'
GO

Granting Administrator access:
This access is usually give to the DBA's
USE [msdb]
GO
CREATE USER [DBAUserName] FOR LOGIN [DBALoginName]
GO
EXEC sp_addrolemember N'ServerGroupAdministratorRole', N'DBAUserName'
GO

4 comments:

Elizabeth J. Neal said...

I am very enjoyed for this blog. Its an informative topic. It help me very much to solve some problems. Its opportunity are so fantastic and working style so speedy. archive management

Elizabeth J. Neal said...

Great post, and great website. Thanks for the information! Alexander Mirza CEO

Huongkvb said...

Đặt vé máy bay tại Aivivu, tham khảo

vé máy bay đi Mỹ giá bao nhiêu

ve may bay eva tu my ve vn

vé máy bay từ frankfurt đi hà nội

ve may bay tu nga ve viet nam

giá thuê máy bay từ anh về việt nam

chuyến bay từ Paris về Hà Nội

khách sạn cách ly ở tây ninh

chuyến bay chuyên gia về việt nam

springmaids said...

The an area of the house that will require intensive cleaning has to be your bathroom. It's where any development for molds together with bacterial growing begins. Utilizing deep maintenance, you can stop the spreading for germs and ensure that your health is not going to get infected. Our credentialed cleaners can eliminate the dust together with grime the fact that develops in the future. We render one of the best bathroom maintenance service during Dubai. Sanitization within the entire powder room, scrubbing toilets, cleaning showers, wetmopping the carpeting / flooring, and impartial more compared with this. Utilizing the right products and services and specialized intervention will stop any bacterial particular breed. House Maid dubai

Post a Comment

Ads