A role is a collection of related system and object privileges that you can grant to user and other roles. This week's discussion focus on applications of role.

 

1. Why do we need to use roles?

2. How to grant privilege (such as CREATE SESSION) to a role?

3. How to grant role to a user?

4. How to revoke a role from a user?

Please make sure to answer each of the question.