Manage Database Object Permissions
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.
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.
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.
IT & Cybersecurity certification hands on practice labs and practice exams for certifications and skill development.
See the full benefits of our immersive learning experience with interactive courses and guided career paths.