ساخت و تنظیم دسترسی ها برای یک کاربر در 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