Configure user permission to SQL database user in SQL Server Management Studio


Staff member
Database user won’t have enough permission to access all the queries so here we can check how to assign permission to MSSQL database user.
  • Login to SQL server Management studio.
  • Now click on particular “Database” and select the table for which you need required permission.
  • After that right click on that table and choose “Properties” option.
  • A new window will appear where you have to select “Permissions” tab.
  • Now click on Search button and after that click on “Object types” button.
  • Now from “Select Object Types” window, you have to click on “Users”.
  • Click on “OK” button.
  • You have to click on “Browse” button and select your desired database user and hit “OK”.
  • In another window “Select Users or Roles” click on “OK”.
  • Now assign the required permissions to your database user.
From all above steps you have assigned required permission to your MSSQL database user.