This article will guide you on how to assign specific permissions to SQL Server database user for accessing a table residing in the database. Kindly follow the below mentioned steps, in order to proceed:

Login to the SQL Server via SQL Server Management Studio, by using the below mentioned login details as shown in the following image:

Server type: Database Engine

Server name: IP address,1533

Authentication: SQL Server Authentication

Login: SQL Server database user

Password: As per set by you

Select your SQL database, Expand database name then select the table residing in that database for which you want to assign the required permissions to that database user, as shown in the following image:

Right click on that table, and select Properties. Click on Permissions option from Table Properties dialog box.

I agree that my personal data via chat, to be processed by AccuWebHosting is for the purpose of providing support. The whole data shall be processed and transmitted in accordance with the General Data Protection Regulation (GDPR).