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

Exercise

Removing user privileges

It seems that success on the loan platform team is contagious. One of the team members, Kim Lopez, has been promoted and will be taking on a project management role. She won't need to make any modifications to the loan data going forward. However, having the ability to query the loan table will still be useful in her new role.

Instructions

100 XP
  • Remove the INSERT, UPDATE, and DELETE privileges that were granted to user account klopez for the loan table in the development schema.