Lesson 2: Configure permissions on database objects

Analytics Platform System (PDW)

Granting a user access to a database involves three steps. First, you create a login. The login

lets the user connect to the SQL Server Database Engine. 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.

To complete this tutorial, you need SQL Server Management Studio and access to a SQL Server

instance.

Install

Management Studio.

If you don’t have access to a SQL Server instance, select your platform from the following links.

If you choose SQL Authentication, use your SQL Server login credentials.

:

Download SQL Server 2022 Developer Edition.

:

Download SQL Server 2022 in a container.

We are listening:

If you find something outdated or incorrect in this article, such as a step

or a code example, please tell us. You can click the

button in the

section at the bottom of this page. We read every item of feedback about SQL, typically the

next day. Thanks.

７

Note

The

learning path provides more in-depth

content, along with practical examples.

７

Note

This lesson relies on objects created in. Complete

Lesson 1 before continuing on to lesson 2.