Exercise ( Data Control Language 1)

  1. Create a user named JOHN.
  2. Create a Role named ‘DEPT_MANAGERS’
  3. Grant Select, Update permissions on Employee table to DEPT_MANGAGERS role.
  4. Create a Role named ‘CHIEF_MANAGERS’.
  5. Grant Select, Update, Delete, Insert permissions on Employee to CHIEF_MANAGERS.
  6. Grant DEPT_MANAGERS role to SCOTT.
  7. Grant CHIEF_MANAGERS role to JHON.
  8. Revoke update on permission on Salary column of Employee table from DEPT_MANAGERS.
  9. Revoke update on employee from DEPT_MANAGERS
  10. Assign DEPT_MANAGERS role to everyone in the database.