Adding Execute to readonly account

General
1

Hello

If you want to have a ro account from Grafana or for Centralization, you have to grant execute on the SQLWatch DB.

This can be done using the following SQLu
use SQLWATCH
GO
CREATE ROLE db_execute;
GO
GRANT EXECUTE TO db_execute;
GO
Then add this role plus db_datareader to your account.

As I am not a SQL guy - I am sysadmin :slight_smile: , I hope this will help people like me :wink:

Best regards

1 Like
2

Hi,

Yep, that’s a good way. I thought this was documented but cannot find it.

Thanks for shaing.