IT блог системного администратора - SQL Management Studio

Используя SQL Server Management Studio, подключитесь к серверу:
Expand ‘Security’ then right-click on ‘Logins’.
Select ‘New Login’. The new login window will open in a new window.
Under ‘Login name’ enter an appropriate name for the account, for example ‘db1_readonly’
Select ‘SQL Server Authentication’
Under ‘Password’ and ‘Confirm password’ enter and appropriate password
Select ‘User Mapping’ from the left hand list
Under ‘Users mapped to this login’ select the database the user will have access to
Under ‘Database role’ elect db_datareader’
Click ‘OK’ to save the changes.

SQL