| title | Lesson 2: Configuring Permissions on Database Objects | Microsoft Docs | |
|---|---|---|
| ms.custom | ||
| ms.date | 06/13/2017 | |
| ms.prod | sql-server-2014 | |
| ms.reviewer | ||
| ms.technology | t-sql | |
| ms.topic | conceptual | |
| helpviewer_keywords |
|
|
| ms.assetid | f964b66a-ec32-44c2-a185-6a0f173bfa22 | |
| author | VanMSFT | |
| ms.author | vanto | |
| manager | craigg |
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: