user name lost from dictionary

Started by Elielson Fontaneziover 23 years ago2 messagesbugsgeneral
Jump to latest
#1Elielson Fontanezi
ElielsonF@prodam.sp.gov.br
bugsgeneral

Hi Every Body!

I would like to know if someone has seen the behavior described
below.

By considering a DLL like this:

CREATE TABLE "recursos_materiais" (
"nr_rec_mat" smallint NOT NULL,
"dc_rec_mat" character varying(100),
"in_situacao_rec_mat" character(1),
Constraint "recursos_materiais_pkey" Primary Key ("nr_rec_mat")
);

REVOKE ALL on "recursos_materiais" from PUBLIC;
GRANT ALL on "recursos_materiais" to "user_fomacao_des"; --< Here is the
point in question

And after mounths of work on postgresql you get a error stating that you
do
not have privileges access on "recursos_materiais" because
you checked this has happend:

CREATE TABLE "recursos_materiais" (
"nr_rec_mat" smallint NOT NULL,
"dc_rec_mat" character varying(100),
"in_situacao_rec_mat" character(1),
Constraint "recursos_materiais_pkey" Primary Key ("nr_rec_mat")
);

REVOKE ALL on "recursos_materiais" from PUBLIC;
GRANT ALL on "recursos_materiais" to "131"; --< What is it?

Is that a bug?

..............................................
A Question...
Since before your sun burned hot in space
and before your race was born,
I have awaited a question.
Elielson Fontanezi
DBA Technical Support - PRODAM
Parque do Ibirapuera s/n - SP - BRAZIL
+55 11 5080 9493

#2Joe Conway
mail@joeconway.com
In reply to: Elielson Fontanezi (#1)
bugsgeneral
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