--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