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

Exercise

Granting user privileges

Sandra Gold's first development project is the creation of an online platform for processing loans. This platform will be used to perform actions such as registering new loan applications and updating loan terms. Recall that loan data is stored in the loan table of the sba database. Your user account can grant privileges to tables in the sba database. In this exercise, you will grant privileges that Sandra Gold requires to develop the platform for managing loan processing.

Instructions 1/4

undefined XP
  • 1
    • Grant the INSERT privilege on the loan table to the sgold role.
  • 2
    • Grant the UPDATE privilege on the loan table to the sgold role.
  • 3
    • Grant the SELECT privilege on the loan table to the sgold role.
  • 4
    • Grant the DELETE privilege on the loan table to the sgold role.