From the course: Database Foundations: Administration
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Group permissions
- [Instructor] Just like you can use schemas to group multiple tables together, you can group multiple individual users together as well. This makes managing permissions easier when the responsibilities of your users fall into distinct categories. When you think about your own organization or business, you probably have different departments that handle separate aspects of the business. You might have a shipping department, and a customer service department, and a marketing department. Each of these departments would have their own group of dedicated employees, but each department's employees all require access to the same set of tables within the database. You can follow the same departmental model when setting up your user access permissions. Each database user gets their own unique username and password login account. You can then create a single group role account for each department. Next, each individual user gets…
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.