From: | "Carlos H(dot) Reimer" <carlosreimer(at)terra(dot)com(dot)br> |
---|---|
To: | <rodrigo(dot)sakai(at)zanthus(dot)com(dot)br> |
Cc: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | RES: Hiding table structure information |
Date: | 2006-06-26 20:48:11 |
Message-ID: | PEEPKDFEHHEMKBBFPOOKMENNDBAA.carlosreimer@terra.com.br |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Yes, a but even so, if the client uses a tool like pgAdmin, he can see all
the database structure. It?s because this kind of tool uses data from the
pg_catalog schema.
Maybe the question should be reformulted to: is there a way to hide
pg_catalog schema? I think it can?t not be done because all metadata are
there, but maybe somebody can see a solution.
Thanks in advance,
Reimer
> -----Mensagem original-----
> De: Rodrigo Sakai [mailto:rodrigo(dot)sakai(at)zanthus(dot)com(dot)br]
> Enviada em: segunda-feira, 26 de junho de 2006 17:03
> Para: carlosreimer(at)terra(dot)com(dot)br; pgsql-admin(at)postgresql(dot)org
> Assunto: RES: [ADMIN] Hiding table structure information
>
>
> I think you have to use a view! You create a view on this table specifying
> only the columns the user may have access, and then you give privileges on
> this view instead of giving privileges on the table!
>
>
>
> -----Mensagem original-----
> De: pgsql-admin-owner(at)postgresql(dot)org
> [mailto:pgsql-admin-owner(at)postgresql(dot)org] Em nome de Carlos H. Reimer
> Enviada em: segunda-feira, 26 de junho de 2006 14:40
> Para: pgsql-admin(at)postgresql(dot)org
> Assunto: [ADMIN] Hiding table structure information
>
> Hello,
>
> Is there a way to hide the table definition structure from an
> user, even if
> the user has privileges to select data from that table?
>
> Reimer
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2006-06-26 20:59:30 | Re: 8.1.3 - autovacuum question |
Previous Message | Benjamin Krajmalnik | 2006-06-26 20:44:25 | Re: Using PostgreSQL and MIcrosoft SQLServer on the same server |