TechBrothersIT is the blog spot and a video (Youtube) Channel to learn and share Information, scenarios, real time examples about SQL Server, Transact-SQL (TSQL), SQL Server Database Administration (SQL DBA), Business Intelligence (BI), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Data Warehouse (DWH) Concepts, Microsoft Dynamics AX, Microsoft Dynamics Lifecycle Services and all other different Microsoft Technologies.
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