From the course: Complete Guide to SQL for Data Engineering: from Beginner to Advanced
Join today to access over 24,400 courses taught by industry experts.
Challenge: Create a role - SQL Tutorial
From the course: Complete Guide to SQL for Data Engineering: from Beginner to Advanced
Challenge: Create a role
(bubbly electronic music) - [Instructor] Our retail store have hired a new team member, and the name of that team member is Bob. Our retail store team wants to give Bob some specific permissions to view the product details. Let's create a user for Bob and grant him the select permission.
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.
Contents
-
-
-
-
-
-
-
-
-
-
-
(Locked)
Introduction to database security5m 55s
-
(Locked)
Understanding users and roles in SQL4m 41s
-
(Locked)
Creating users and assigning roles8m 35s
-
(Locked)
Granting and revoking permissions9m 33s
-
(Locked)
Using roles for permission management6m 34s
-
(Locked)
Best practices for managing roles and permissions7m 10s
-
(Locked)
Challenge: Create a role27s
-
(Locked)
Solution: Create a role1m 1s
-
(Locked)
-
-
-
-