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
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.
No comments:
Post a Comment