We can restrict SQL database users to fire some overcritical queries, e.g. Update, Delete, etc by means of SQL Server Management Studio.
This article will direct you on the technique to assign specific permissions to SQL Server database. Kindly observe the below noted steps, before proceeding:
Login to the SQL Server through SQL Server Management Studio, through using the beneath noted login information,
Server type: Database Engine
Servername: IP address, 1533
Authentication: SQL Server Authentication
Login: SQL Server database user
Password: As per set with the aid of you
Select your SQL database; Expand database name then pick out the table present in that database for which you need to assign the specified permissions to that database user.
Right click on that table, and choose Properties. Click on >> Permissions option from Table Properties dialog box.
Click on >> Search button and click on >>Object Types button.
Now, take a look at the Users option
Click on OK button
Click on Browse button and select your SQL database user and click >> OK.
Once more click on >> OK button from “Select Users or Roles” Dialog box.
Assign suitable permissions to the user.
By following above steps, you may assign specific permissions to the particular database person in SQL Server.
Note: The above steps are performed on SQL Server 2008 R2 Express Edition.