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 should read it
- Network basics: Part 3 - DNS Server
- Find User in SQL Server
- How to start and stop services in MS SQL Server
- New points in SQL Server 2017
- SQL Server 2019 - Microsoft Relational Database Management System
- Learn about the architecture of MS SQL Server
- Instructions for installing MS SQL Server
- How to set up your own Git server on Linux
May be interested
- How to change DNS server on the most popular routerschanging 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 ?. 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)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 serverraspberry 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 Chromebookyou 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 3microsoft 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 2017the 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 10if 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?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 8no 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