user name lost from dictionary

From: Elielson Fontanezi <ElielsonF(at)prodam(dot)sp(dot)gov(dot)br>
To: "'pgsql-bugs(at)postgresql(dot)org'" <pgsql-bugs(at)postgresql(dot)org>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: user name lost from dictionary
Date: 2002-10-10 11:28:17
Message-ID: A799F7647794D311924A005004ACEA9708A246B6@cprodamibs249.prodam
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-general

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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message pgsql-bugs 2002-10-10 13:02:14 Bug #795: null resulting from left join corrupts select
Previous Message Ruslan A Dautkhanov 2002-10-10 09:42:31 Re: Creating server-side functions: one simple error

Browse pgsql-general by date

  From Date Subject
Next Message Savita 2002-10-10 11:38:39 Re: Problem running postgre as a windows NT service
Previous Message Nigel J. Andrews 2002-10-10 11:19:42 Re: Problem running postgre as a windows NT service