Skip to content

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

Latest commit

 

History

History
47 lines (37 loc) · 1.98 KB

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

File metadata and controls

47 lines (37 loc) · 1.98 KB

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

[!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:

Next Task in Lesson

Creating a Login