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

title	Lesson 2: Configuring Permissions on Database Objects | Microsoft Docs
ms.custom
ms.date	03/01/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	database permissions
ms.assetid	f964b66a-ec32-44c2-a185-6a0f173bfa22
caps.latest.revision	12
author	edmacauley
ms.author	edmaca
manager	craigg
ms.workload	On Demand

Lesson 2: Configuring Permissions on Database Objects

[!INCLUDEtsql-appliesto-ss2008-all-md] Granting a user access to a database involves three steps. First, you create a login. The login lets the user connect to the [!INCLUDEssDEnoversion]. Then you configure the login as a user in the specified database. And finally, you grant that user permission to database objects. This lesson shows you these three steps, and shows you how to create a view and a stored procedure as the object.

This lesson contains the following topics:

• Creating a Login

• Granting Access to a Database

• Creating Views and Stored Procedures

• Granting Access to a Database Object

• Summary: Configuring Permissions on Database Objects

Next Task in Lesson

Creating a Login