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.