SQL SERVER 2017 READONLY TO SPECIFIC DATABASE


--USERNAME ADI HASELU
--DB NAME HASEL
CREATE LOGIN HASELU
    WITH PASSWORD = 'HASELU';
USE HASEL;
CREATE USER HASELU FOR LOGIN HASELU;
GO 
GRANT SELECT TO HASELU

USE master;
GO
DENY VIEW ANY DATABASE TO HASELU;

USE HASEL
GO
SP_DROPUSER 'HASELU'  
GO
SP_CHANGEDBOWNER 'HASELU' 

USE master;
GO
ALTER AUTHORIZATION ON DATABASE::HASEL TO HASELU;
GO

TESTED ON SQL SERVER 2017