ozar_toolkit_setup

readme.md

Setting up for minimal user (non-dba) permissions

One-time steps

USE master;
GO

CREATE CERTIFICATE diagnostics_cert
    ENCRYPTION BY PASSWORD = '5OClockSomewhere'
    WITH SUBJECT = 'Certificate for sp_BlitzFirst',
    START_DATE = '20130711', EXPIRY_DATE = '21000101';
GO

CREATE LOGIN diagnostics_login FROM CERTIFICATE diagnostics_cert;
GO

CREATE USER sp_BlitzFirst_login FROM CERTIFICATE diagnostics_cert;
GO

-- add database exec permissions
GRANT EXECUTE ON dbo.sp_BlitzFirst TO sp_BlitzFirst_login;
GRANT EXECUTE ON dbo.sp_BlitzCache TO sp_BlitzFirst_login;
GRANT EXECUTE ON dbo.sp_BlitzIndex TO sp_BlitzFirst_login;
GRANT EXECUTE ON dbo.sp_Blitz TO sp_BlitzFirst_login;
GO

GRANT EXECUTE ON dbo.sp_BlitzFirst TO [diagnostic_user];
GO

Install Toolkit

-- install Toolkit

ADD SIGNATURE TO sp_BlitzFirst BY CERTIFICATE sp_BlitzFirst_cert WITH PASSWORD = '5OClockSomewhere';
GO