Lesson 2 | What is a role? |
Objective | Understand how database roles are used |
Simplified granting of privileges: | By grouping privileges into a role, you reduce the amount of effort needed to grant multiple privileges. |
Simplified management of privileges: | To change the object privileges for a group of users assigned to a role, you can change the privileges for the role instead of the privilegesfor each individual user |
Dynamically changing security privileges: | A user can assume more than one role, and can change roles while connected to the database. You can enable and disable roles as an administrator. |
Application roles: | You can create application roles, which allow all users of an application to have the same privileges while using the application. |