---
title: "Lesson 2: Configuring Permissions on Database Objects | Microsoft Docs"
ms.custom: ""
ms.date: "03/01/2017"
ms.prod: "sql"
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"
monikerRange: ">= aps-pdw-2016 || = azuresqldb-current || = azure-sqldw-latest || >= sql-server-2016 || = sqlallproducts-allversions"
---
# Lesson 2: Configuring Permissions on Database Objects
[!INCLUDE[tsql-appliesto-ss2008-all-md](../includes/tsql-appliesto-ss2008-all-md.md)]
Granting a user access to a database involves three steps. First, you create a login. The login lets the user connect to the [!INCLUDE[ssDEnoversion](../includes/ssdenoversion-md.md)]. 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](../t-sql/lesson-2-1-creating-a-login.md)  
  
-   [Granting Access to a Database](../t-sql/lesson-2-2-granting-access-to-a-database.md)  
  
-   [Creating Views and Stored Procedures](../t-sql/lesson-2-3-creating-views-and-stored-procedures.md)  
  
-   [Granting Access to a Database Object](../t-sql/lesson-2-4-granting-access-to-a-database-object.md)  
  
-   [Summary: Configuring Permissions on Database Objects](../t-sql/lesson-2-5-summary-configuring-permissions-on-database-objects.md)  
  
## Next Task in Lesson  
[Creating a Login](../t-sql/lesson-2-1-creating-a-login.md)