Hello On 2021-06-21 12:40, Atul Kumar wrote:
Hi, 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';
A user without login privilege is usally called a group and is used for bundling privileges that you can grant granting the role to individual users. This helps you to keep more order and structure in your DB privileges.
You may also have a user that can login and for whatever reason must be restricted access for a certain time.
as the user is created with login privileges then what is the use such user ?
See above.
Where such users having no login privileges can be used ?
Yes, you use it as a group. -- Charles Clavadetscher Spitzackerstrasse 9 CH - 8057 Zürich https://www.swisspug.org +------------------------+ | ____ ______ ___ | | / )/ \/ \ | | ( / __ _\ ) | | \ (/ o) ( o) ) | | \_ (_ ) \ ) _/ | | \ /\_/ \)/ | | \/ <//| |\\> | | _| | | | \|_/ | | | | Swiss PostgreSQL | | Users Group | +------------------------+
