How to decentralize users in MS SQL Server

To decentralize, use 1 of 2 ways.

Method 1: Use T-SQL

Use <database name>
Grant <permission name> on <object name> to <username\principle>

For example:

To authorize the user named TestUser on the object TestTable on the database named TestDB, run the following query.

USE TestDB
GO
Grant select on TestTable to TestUser

Method 2: Use SQL Server Management Studio SSMS

Step 1 : Connect to the database, expand the directory as shown in the image below.

How to decentralize users in MS SQL Server Picture 1

Open the Security> Users folder and find the username you want to decentralize

Step 2 : Right-click TestUser and select Properties. The screen below will appear.

How to decentralize users in MS SQL Server Picture 2

TestUser user management screen

Step 3 : Use Search to search and then select the object you want to decentralize, here is the Table TestTable.

Step 4 : Click on the TestTable table , then select the Grant checkbox for the operations in the list below as shown in the image below. In this example, the right to select a table (Select) is given.

How to decentralize users in MS SQL Server Picture 3

Tick ​​select the authority box

Step 5 : Click OK to complete the authorization.

Isabella Humphrey

Update 25 May 2019