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
