The PostgreSQL Role Part 1


Article Overview

In this article, we will cover the PostgreSQL database role object that groups together one or more privileges and can be assigned to users. A role is a collection of permission or privileges that can be granted to one or more users or other roles.

There are two types of roles in PostgreSQL.

Login Role – Roles that can log in are called login roles. They are equivalent to users in other database systems. Group Role – When roles contain other roles, they are called group roles. Create Role

In this section, with the help of