1. Learn
    2. /
  2. Courses
    3. /
  3. Creating PostgreSQL Databases

Exercise

Schema privileges

The new software development team members are eager to get started on the loan management project. But Sandra, as the team lead, is not comfortable with so many people having direct access to the production version of the loan database (in the public schema). The rapidly growing team must implement some software development best practices which include setting up a development environment that is separated from the production environment. In this exercise, you will create a new schema to represent this development environment and grant members of the software development team privileges on this schema.

Instructions

100 XP
  • Create a new schema named development.
  • Grant the usage privilege on the development schema to dev_team.
  • Create a version of the loan table under the development schema.
  • Grant SELECT, INSERT, UPDATE, and DELETE privileges to the dev_team group for all development schema tables.