Exercise

Rescinding group membership

The technology team at the SBA would like to be more proactive in assigning database access by group. Each user account must belong to at least one group. All project managers will be members of a project_management group. Therefore, Kim Lopez, should be added to this account and removed from the dev_team group. This exercise will allow you to manage group membership for these teams.

Instructions

100 XP

Create a new group named project_management.
Grant the project_management group the SELECT privilege on the loan table.
Add user klopez to the project_management group.
Remove user klopez from the dev_team group.