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 <usernameprinciple>

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.

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.

You've just finished reading the article "How to decentralize users in MS SQL Server" edited by the TipsMake team. You can save how-to-decentralize-users-in-ms-sql-server.pdf to your computer here to read later or print it out. We hope this article has provided you with many useful tech tips and tricks. You can search for similar articles on tips and guides. Thank you for reading and for following us regularly.