4 ms·
Everything in PostgreSQL is a role. It's just named such that when a ROLE allows `login` it's considered a user
by _jhqp 2y ago
Everything in PostgreSQL is a role.
It's just named such that when a ROLE allows `login` it's considered a user
- skissane 2y agoThis is part of what many people find so confusing. In most systems “role” is a group (or something closely resembling a group), not a user. The weird terminology confuses beginners
- _jhqp 2y agoIt's a bit confusing and legacy. All roles function like you would expect groups to function A role that is not allowed to login is a `group`. While the CREATE USER and CREATE GROUP commands still exist, they are simply aliases for CREATE ROLE.
- orthoxerox 2y agoSomeone was feeling very clever when they came up with this idea.
- paulddraper 2y agoIt makes a lot of sense, especially since in the SQL standard, you can grant privileges to "users" or "roles." Might as well simplify the mental model and make them the same.
- cqqxo4zV46cp 2y agoTo me, the comment you are replying to is saying that you should^ DIFFERENTIATE roles by service, not ‘end user’.