Connecting to target databases : Pre-configuration for monitoring target databases : Microsoft SQL Server target database pre-configuration : Required privileges for monitoring via SQL Trace
 
Required privileges for monitoring via SQL Trace
The following privileges are required when you monitor a Microsoft SQL Server database using the SQL Trace collection method and privilege and metadata policies.
Policy type
Required privileges
Privileges
SELECT on:
sys.columns
sys.database_role_members
sys.database_permissions
sysobjects
sys.database_principals
sys.sql_logins
EXECUTE on:
sp_helpsrvrolemember
Metadata
SELECT on:
information_schema.columns
sysindexes
sysobjects
information_schema.routines
sys.objects obj
sys.sql_modules
information_schema.views
See also
Adding (or modifying) a target connection
Configuring Microsoft SQL Server monitoring