Mastering PostgreSQL 12 - Third Edition

Creating and modifying users

After this theoretical introduction, it is time to actually create users and see how things can be used in a practical example:

test=# CREATE ROLE  bookkeeper NOLOGIN;  
CREATE ROLE test=# CREATE ROLE  joe LOGIN;  
CREATE ROLE test=# GRANT  bookkeeper TO joe;  
GRANT ROLE 

The first thing that has been done here is that a role called bookkeeper has been created.

Note that we don't want people to log in as bookkeeper, so the role is marked as NOLOGIN.

You should also note that NOLOGIN is the default value if you use the CREATE ROLE clause. If you prefer the CREATE USER clause, the default setting is LOGIN.

Then, the joe role is created and marked as LOGIN. Finally, the bookkeeper role is assigned to the joe role, so that ...