| From: | Carlos Mennens <carlos(dot)mennens(at)gmail(dot)com> | 
|---|---|
| To: | pgsql-general(at)postgresql(dot)org | 
| Subject: | Role Authentication Failure | 
| Date: | 2013-04-15 14:30:23 | 
| Message-ID: | CAAQLLO4PjBaSYxJyOfFw0uf5saakQD-_iqSaVF608dYdYNVATQ@mail.gmail.com | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-general | 
I can't understand what is going on with my PostgreSQL server. For
some reason after I GRANT my role 'carlos' to the 'dba' group role, I
lose the ability to login. I've reset the password over and over for
'carlos' and even reversing the grant doesn't remedy the
authentication failure. The logs are extremely vague:
2013-04-14 00:41:52 EDT FATAL: password authentication failed for user "carlos"
My roles look as follows:
postgres=# \dg
                             List of roles
 Role name |                   Attributes                   | Member of
-----------+------------------------------------------------+-----------
 carlos    | Superuser, Create role, Create DB, Replication | {}
 dba       | No inheritance, Cannot login                   | {}
 postgres  | Superuser, Create role, Create DB, Replication | {}
As you can see I've removed 'dba' role from 'carlos' but he still
can't login. My only option is to DROP the 'carlos' role and re-create
him.
The problem occurs when I:
GRANT dba TO carlos;
I don't understand which role (carlos or dba) needs INHERIT or
NOINHERIT if that's causing this...
--
Carlos Mennens
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2013-04-15 15:27:50 | Re: Role Authentication Failure | 
| Previous Message | whiplash | 2013-04-15 13:29:52 | Re: False unique constraint violation (exception block) |