Create and grant roles
You must log into the database as Pat before proceeding with this page.
Execute the statements on the right, the following operations are performed:
- Create roles 'Mgr' and 'custService'
- Grant role 'Mgr' to Joe, manager of customer service department
- Grant role 'custService' to Bob, an employee of the customer service department
- Grant SELECT, INSERT, UPDATE, and DELETE privileges to role 'Mgr' on table 'credit_card'
- Grant SELECT, INSERT, and UPDATE privileges to role 'custService' on table 'credit_card'