Login vs group roles in PostgreSQL - Quick Revision & Key Differences

Recall & Review

beginner

What is a login role in PostgreSQL?

A login role is a user account that can connect to the database. It has permission to log in and perform actions based on its privileges.

beginner

What is a group role in PostgreSQL?

A group role is a collection of roles. It cannot log in but can own privileges that are shared with its member roles.

beginner

Can a group role log in to the database?

No, group roles cannot log in. Only login roles have the ability to connect to the database.

intermediate

How do group roles help manage permissions?

Group roles let you assign permissions once to the group. Then all member roles inherit those permissions, making management easier.

intermediate

How do you add a login role to a group role in PostgreSQL?

Use the SQL command: GRANT group_role TO login_role; This makes the login role a member of the group role.

Which PostgreSQL role type can connect to the database?

A Group role

B Login role

C Both login and group roles

D Neither

Only login roles have the ability to log in and connect to the database.

What is the main purpose of a group role?

A To own and share permissions among member roles

B To store data

C To log in to the database

D To create tables

Group roles are used to manage permissions collectively for their member roles.

How do you make a login role a member of a group role?

A CREATE ROLE login_role IN group_role;

B ADD login_role TO group_role;

C ALTER ROLE login_role SET group_role;

D GRANT group_role TO login_role;

The correct syntax to add a login role to a group role is: GRANT group_role TO login_role;

Can a group role own database objects like tables?

A Only superusers can own objects

B No, only login roles can own objects

C Yes, group roles can own objects

D Group roles can own objects only if they can log in

Group roles can own database objects and assign privileges to their members.

If a login role is a member of multiple group roles, what permissions does it have?

A Permissions from all group roles it belongs to

B Only permissions assigned directly to the login role

C No permissions from group roles

D Only permissions from the first group role

A login role inherits permissions from all group roles it is a member of.

Explain the difference between a login role and a group role in PostgreSQL.

Think about who can log in and how permissions are shared.

Describe how group roles simplify permission management in PostgreSQL.

Consider how managing permissions individually compares to using groups.