With all the database features, there is restrict database access feature is also provided by MSSQL. Normally, there are 3 access modes are available Single User, Multiple User and Restricted User.
You can easily change the User access mode in MSSQL Management Studio with below steps:
You can easily change the User access mode in MSSQL Management Studio with below steps:
- Login to SQL Management studio.
- Right click on particular database for which you have to set user access mode and select properties.
- A new window will appear and you have to click on “Options”.
- Navigate to State >> Restrict Access
- Here you will find Drop-Down for Restrict Access, you have to choose option (single_user, multi_user and restricted_user) according to your requirement.
- Click on “OK” button.