ساخت و تنظیم دسترسی ها برای یک کاربر در SQL

--Step 1: (create a new user)

create LOGIN mohammad WITH PASSWORD='1234', CHECK_POLICY = OFF;

-- Step 2:(deny view to any database)

USE master;

GO

DENY VIEW ANY DATABASE TO mohammad;

-- step 3 (then authorized the user for that specific database , you have to use the master by doing use master as below)

USE master;

GO

ALTER AUTHORIZATION ON DATABASE::mohammad_db TO mohammad;

GO