How to Provide Explicit Permission to Specific Tables to a User in a database of SQL Server - SQL Server DBA Tutorial

In this video you will learn step by step process of providing explicit Table permissions to a User in SQL Server using SQL Server Management studio as well as using T-SQL script. It also walks you though best practices of adding tables and other objects to user's permissions, how to give select permission on a specific table, how to give update permissions on a specific table in SQL Server database.

Script to provide Select permission to user

USE [SalesOrders]
GO

 GRANT SELECT ON [dbo].[Customers] TO [TECHBROTHERS\kscott]
GO



Grant Permissions to Users in SQL Server Database