Create a New User in SQL server and Grant only a Given DB Access only

-- 1.

create LOGIN sa_uat2 WITH PASSWORD='abc123', CHECK_POLICY = OFF;


--2.

USE master;

GO

DENY VIEW ANY DATABASE TO sa_uat2;



-- 3.
USE master;

GO

ALTER AUTHORIZATION ON DATABASE::DB_Name_You_need TO sa_uat2;

GO