lesson-2-5-summary-configuring-permissions-on-database-objects.md

title	Summary: Configuring Permissions on Database Objects | Microsoft Docs
ms.custom
ms.date	03/14/2017
ms.prod	sql-non-specified
ms.prod_service	database-engine, sql-database, sql-data-warehouse, pdw
ms.service
ms.component	t-sql
ms.reviewer
ms.suite	sql
ms.technology	database-engine
ms.tgt_pltfrm
ms.topic	article
applies_to	SQL Server 2016
helpviewer_keywords	configuring permissions on databases
ms.assetid	d0ecf297-27af-43a4-918c-31c354b3a96e
caps.latest.revision	13
author	edmacauley
ms.author	edmaca
manager	craigg
ms.workload	Inactive

Lesson 2-5 - Summary - Configuring Permissions on Database Objects

[!INCLUDEtsql-appliesto-ss2008-all-md] Logins give users permissions to connect to [!INCLUDEssNoVersion]. Users are logins that can access a specific database. Use the GRANT statement to give users permission to read and to access and change the data.

A view is a single SELECT statement and looks like a table to the user. A stored procedure is one or more [!INCLUDEtsql] statements that execute as a batch.

Next Lesson in Tutorial

Lesson 3: Deleting Database Objects