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

Exercise

Using the granted privileges

Now that Sandra has been granted the INSERT, UPDATE, SELECT, and DELETE privileges, she has been able to use the loan table. She successfully manages what data is in the table. However, she is working on an aspect of her project that requires an alteration to the loan table. Specifically, she would like to start capturing the approval date AND time of a loan. This requires altering the structure of the table using the following commands:

ALTER TABLE loan DROP COLUMN approval_date;
ALTER TABLE loan ADD COLUMN approval_dt DATETIME;

In this exercise, you will change ownership of the loan table so that Sandra can begin capturing both the approval date and approval time.

Instructions

100 XP
  • Make sgold the owner of the loan table so that Sandra can execute the ALTER TABLE commands above.