CommencerCommencer gratuitement

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.

Cet exercice fait partie du cours

Creating PostgreSQL Databases

Afficher le cours

Exercice interactif pratique

Essayez cet exercice en complétant cet exemple de code.

-- Grant the INSERT privilege
GRANT ___ ON loan TO ___;
Modifier et exécuter le code