天天看点

Authority setting for sql server activity monitor read permissions

Is there anyway to provide either the activity monitor or "read" access to what is happening on a sqlserver (2005) without being a sys admin? the following is the answer.

The rights are:

1) Permissions (Open Server Properties then select Permissions)

ALTER TRACE

CONNECT SQL

VIEW ANY DATABASE

VIEW ANY DEFINITION

VIEW SERVER STATE

2) Server roles

Public

3) Database Roles

public (all databases)

db_datareader (all databases)

SQLAgentUserRole (msdb only)

The ALTER TRACE authority is only needed if you want to allow members of the Windows group to run traces.