| title | Summary: Configuring Permissions on Database Objects | Microsoft Docs | |
|---|---|---|
| ms.custom | ||
| ms.date | 06/13/2017 | |
| ms.prod | sql-server-2014 | |
| ms.reviewer | ||
| ms.technology | ||
| ms.topic | conceptual | |
| helpviewer_keywords |
|
|
| ms.assetid | d0ecf297-27af-43a4-918c-31c354b3a96e | |
| author | VanMSFT | |
| ms.author | vanto | |
| manager | craigg |
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.