Additional Information required on SQL Server Monitor

Products

• CA Application Performance Management SaaS

Issue/Introduction

Setting up SQL Server(database) monitoring . We need to have the SysAdmin role.

Is it possible to run this monitor with regular user read access?

 

 

Environment

Release : SAAS

Component :

Cause

Per Engineering, it should have an admin role to access these database tables. Required by the database access policy for the stored procedure,  not for APM nor SQL Agent. 

 

 

Resolution

Workaround.

https://docs.microsoft.com/en-us/sql/relational-databases/stored-procedures/grant-permissions-on-a-stored-procedure?view=sql-server-ver1