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:
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
3 comments:
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
Great post, and great website. Thanks for the information! Alexander Mirza CEO
Đặ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
Post a Comment