- Используя 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
SQL Management Studio – Права на чтение
- Details
- Parent Category: главный раздел
- Category: SQL
- Hits: 3264