Steps to change user access mode in MSSQL

kumkumsharma

Administrator
Staff member
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:
  • 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.
 
Top