1. Learn
    2. /
  2. Courses
    3. /
  3. Creating PostgreSQL Databases

Exercise

Working with users and groups

Sandra's project at the SBA is turning into a great success. Loan processing is now much faster than before the rollout of the online loan platform. This results in the growth of the team responsible for the loan management platform. Sandra is now leading the team and recently hired 3 new developers. Before the new developers begin their first days on the job, Sandra would like to create database accounts for each user and give each account the same access privileges.

Instructions

100 XP
  • Create new user accounts for Ronald Jones (rjones), Kim Lopez (klopez), and Jessica Chen (jchen).
  • Create a new group named dev_team.
  • Grant the dev_team INSERT, UPDATE, DELETE, and SELECT privileges on the loan table.
  • Add the 3 new user accounts to the dev_team group.