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.

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.

4.4 ★ | 8 Vote

May be interested

  • How to change DNS server on the most popular routersHow to change DNS server on the most popular routers
    changing the dns server settings on your router is not difficult, but every manufacturer uses their own custom interface, which means the process can be very different depending on which router you are owned.
  • What is VPS? VPS used to do? What is VPS different from Server?What is VPS? VPS used to do? What is VPS different from Server?
    what is vps? vps used to do? what is vps different from server ?. when you intend to learn about network data or open the website, you will definitely be introduced to many different server and server services. but server hosting has a lot of tricks
  • Transfer from Linux Mail Server to Exchange Server 2007 (Part 3)Transfer from Linux Mail Server to Exchange Server 2007 (Part 3)
    through the previous two sections we have created users, this article will switch to the user information section. using the new-mailbox command cannot add the information we have in the csv file.
  • 7 great ideas using Raspberry Pi as a server7 great ideas using Raspberry Pi as a server
    raspberry pi is a great solution for many computer projects, from learning programming to remote control a car to building a basic stop-motion animation studio. but do you know that raspberry pi can also be used as a server? here are some ideas for using raspberry pi as a server.
  • How to change DNS server on ChromebookHow to change DNS server on Chromebook
    you can get a faster browsing experience by changing the dns server that your device uses to look up internet names. chromebooks allow users to set up a customized dns server for wireless networks. this article will show you how to do it.
  • Installing and configuring the 2004 ISA Server Firewall - Chapter 3Installing and configuring the 2004 ISA Server Firewall - Chapter 3
    microsoft internet authentication server (ias) is a standard of type radius (remote authentication dial in user service) server used to authenticate users connecting to the isa server 2004 firewall machine.
  • New points in SQL Server 2017New points in SQL Server 2017
    the sql server 2017 version is primarily connected to linux, bringing the power of sql to linux. in short, you can install sql server 2017 on linux, using sql server 2017 on linux-based docker containers. sql server 2017 also allows you to choose development languages, develop it on-premise or cloud-based.
  • Instructions for setting up and managing FTP Server on Windows 10Instructions for setting up and managing FTP Server on Windows 10
    if you want to create a private cloud for sharing and converting large files without restrictions, you can create an ftp server (file transfer protocol server) on your windows 10 computer.
  • What does Windows Server 2016 bring to small and medium businesses?What does Windows Server 2016 bring to small and medium businesses?
    windows server system must be no stranger to users in general and network administrators in particular. this is a system that provides easy interaction as well as user friendliness. today, tipsmake.com will mention the features that windows server 2016 brings to businesses.
  • Create VPN Server on Windows 8Create VPN Server on Windows 8
    no need to install any additional applications, you can easily 'turn' your computer into a vpn server if you're using windows 8. in this way, you can share data from the computer. as a simple lan system in the form of remote access. & a