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-server-2016
ms.reviewer
ms.suite
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	BYHAM
ms.author	rickbyh
manager	jhubbard

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

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