stan <stanb(at)panix(dot)com> writes:
> Just starting to expore setting up roles & useres. I ran this statement:
> GRANT CONNECT ON DATABASE stan TO employee;
> But yet \du still reports:
> employee | Cannot login
> What am I doing wrong?
That's not a permissions issue, it's a role-property issue; the
role is marked as not being allowed to be used as a login role.
Probably because you said CREATE ROLE not CREATE USER.
You can fix it with ALTER ROLE ... LOGIN or something along
that line, check the ALTER ROLE page.
regards, tom lane