How to Decentralize Users in MS SQL Server

How to Decentralize Users in MS SQL Server is easier to understand when the core ideas are paired with practical examples. The sections below explain the topic clearly, highlight useful steps, and point out details that can prevent common errors.

To decentralize, use 1 of 2 ways.

Method 1: Use T-SQL

Use <database name>
Grant <permission name> on <object name> to <usernameprinciple>

For instance,:

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.

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.

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.

Tick select the authority box

Step 5 : Click OK to complete the authorization.