Re: user name lost from dictionary

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