Get startedGet started for free

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

View Course

Hands-on interactive exercise

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

-- Grant the INSERT privilege
GRANT ___ ON loan TO ___;
Edit and Run Code