On Mon, 2021-06-21 at 16:10 +0530, Atul Kumar wrote:
> My question can be silly but I need to ask that if a user is created
> without login privilege then what is the use of below command why
> don't postgres prompt error on it
>
> CREATE ROLE nolog_user WITH PASSWORD 'pass1';
>
> as the user is created with login privileges then what is the use such user ?
The role can be the owner of objects, or it can have members that
inherit privileges.
But setting a password is pointless on a role that cannot login.
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com