-
Details
-
Parent Category: главный раздел
-
Category: SQL
-
-
-
-
Hits: 3154
- Используя 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.