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
Exercise instructions
- Make
sgold
the owner of theloan
table so that Sandra can execute theALTER 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 ___;