How To Create Read Only Server Role In SQL Server 2017
--Step1:Create Server Role with Required Privileges
CREATE SERVER ROLE Readonly
GO
GRANT CONNECT ANY DATABASE TO Readonly
GO
GRANT SELECT ALL USER SECURABLES TO Readonly
GO
--Step2:create login and add to the above role.
USE [master]
GO
CREATE LOGIN [testuser] WITH PASSWORD=N'123'
Go
ALTER SERVER ROLE [Readonly] ADD MEMBER [testuser]
GO
Don't forget to subscribe to our channel.
/ tricksthatmakesmart
/ tricksthatmakeyousmart
/ tricksthatmakeyousmart
