Manage Database Object Permissions

Practice Labs Module
Time
1 hour 2 minutes
Difficulty
Intermediate

The "Manage Database Object Permissions" module provides you with the instructions and devices to develop your hands-on skills in the following topics: Managing SQL Server logins, database users, and roles, Working with database permissions.

Join over 3 million cybersecurity professionals advancing their career
Sign up with
Required fields are marked with an *
or

Already have an account? Sign In »

Overview

Introduction

The Manage Database Object Permissions module provides you with the instructions and devices to develop your hands-on skills in the following topics.

  • Managing SQL Server logins, database users, and roles
  • Working with database permissions

Lab time: It will take approximately 60 minutes to complete this lab.

Exam Objectives

Five exam objectives are covered in this lab.

  • Creating a new role
  • Creating a login
  • Granting access to database
  • Creating views and stored procedures
  • Granting access to a database object

Exercise 1 - Managing SQL Server Logins, Database Users, and Roles

SQL Server logins enable you to connect to SQL Server database engine. You can create them using SQL Server Management Studio or Transact-SQL. While creating new SQL Server logins, you need to select an authentication mode. There are two modes such as Windows Authentication and SQL Server Authentication. Windows Authentication is considered as a more secure mode.

You can create new database users for logins in SQL Server using SQL Server Management Studio or Transact-SQL. The database users must be mapped to existing SQL Server logins. You can add the database users to database roles. The users are assigned permissions based on the roles.

In this exercise, you will create a new SQL Server login and database user. You will map the new user to the new login and provide role-based privileges to them.

Exercise 2 - Working with Database Permissions

SQL Server offers database-level roles that enable you to manage permissions in the databases. There are two types of database-level roles. These are as follows:

Fixed-database role: This type of role is already available in the database. User-defined database role: This type of role needs to be created in the database.

In this exercise, you will work with fixed-database roles and manage permissions.

Learning Partner
Comprehensive Learning

See the full benefits of our immersive learning experience with interactive courses and guided career paths.