Home > Security > OpsMgr database security requirements

OpsMgr database security requirements

OpsMgr MS Action Account:

Server Role – Public

OperationsManager database:
Ø Db_datareader
Ø Db_datawriter
Ø Db_ddladmin
Ø Db_module_users
Ø Public

OpsMgr SDK \ Config

Server Role – Public

OperationsManager database:
Ø Db_datareader
Ø Db_datawriter
Ø Db_ddladmin
Ø Configsvc_user
Ø Dwsynch_users
Ø Sdk_Users
Ø Public

OperationsManagerDW:
Ø Db_datareader
Ø OpsMgrReader
Ø Public

OpsMgr Data Reader

Server Role – Public

Master:
Ø Public
Ø RSExecRole

MSDB:
Ø Public
Ø RSExecRole
Ø SQLAgentOperatorRole
Ø SQLAgentReaderRole
Ø SQLAgentUserRole

Operations ManagerDW:
Ø Db_datareader
Ø OpsMgrReader
Ø Public

Report Server:
Ø Db_owner
Ø Public
Ø RSExecRole

ReportServerTempDB:
Ø Db_owner
Ø Public
Ø RSExecRole

Ops Mgr Data Writer:
OperationsManager database:
Ø Db_datareader
Ø Dwsynch_users
Ø public

OperationsManagerDW:
Ø Db_owner
Ø OpsMgrWriter
Ø Public

Advertisements
Categories: Security
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: