Granting user privileges
Sandra Gold's first development project is the creation of an online platform for processing loans. This platform will be used to perform actions such as registering new loan applications and updating loan terms. Recall that loan data is stored in the loan
table of the sba
database. Your user account can grant privileges to tables in the sba
database. In this exercise, you will grant privileges that Sandra Gold requires to develop the platform for managing loan processing.
This exercise is part of the course
Creating PostgreSQL Databases
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
-- Grant the INSERT privilege
GRANT ___ ON loan TO ___;