Re: [BUGS] user name lost from dictionary - Mailing list pgsql-general

From Joe Conway
Subject Re: [BUGS] user name lost from dictionary
Date
Msg-id 3DA58C28.4000109@joeconway.com
Whole thread Raw
In response to user name lost from dictionary  (Elielson Fontanezi <ElielsonF@prodam.sp.gov.br>)
List pgsql-general
Elielson Fontanezi wrote:
> GRANT ALL on "recursos_materiais" to "user_fomacao_des"; --< Here is the
> point in question
[...snip...]
> REVOKE ALL on "recursos_materiais" from PUBLIC;
> GRANT ALL on "recursos_materiais" to "131"; --< What is it?
>
> Is that a bug?

It looks like someone dropped user_fomacao_des. What happens if you run:

select * from pg_user;
?

You can fix this by doing:
CREATE USER user_fomacao_des WITH SYSID 131 PASSWORD 'password';

HTH,

Joe



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Server locale?
Next
From: Joe Conway
Date:
Subject: Re: bytea type