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.
Diese Übung ist Teil des Kurses
Creating PostgreSQL Databases
Anleitung zur Übung
- Make
sgoldthe owner of theloantable so that Sandra can execute theALTER TABLEcommands above.
Interaktive Übung
Versuche dich an dieser Übung, indem du diesen Beispielcode vervollständigst.
-- Provide sgold with the required table privileges
___ TABLE ___ ___ TO ___;