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 

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to