Get startedGet started for free

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.

This exercise is part of the course

Creating PostgreSQL Databases

View Course

Exercise instructions

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

Hands-on interactive exercise

Have a go at this exercise by completing this sample code.

-- Provide sgold with the required table privileges
___ TABLE ___ ___ TO ___;
Edit and Run Code