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.
Bu egzersiz
Creating PostgreSQL Databases
kursunun bir parçasıdırEgzersiz talimatları
- Make
sgoldthe owner of theloantable so that Sandra can execute theALTER TABLEcommands above.
Uygulamalı interaktif egzersiz
Bu örnek kodu tamamlayarak bu egzersizi bitirin.
-- Provide sgold with the required table privileges
___ TABLE ___ ___ TO ___;