| From: | "Rodrigo Sakai" <rodrigo(dot)sakai(at)zanthus(dot)com(dot)br> |
|---|---|
| To: | <carlosreimer(at)terra(dot)com(dot)br>, <pgsql-admin(at)postgresql(dot)org> |
| Subject: | RES: Hiding table structure information |
| Date: | 2006-06-26 20:02:44 |
| Message-ID: | 000301c6995b$7d5c9150$4700a8c0@TREEZANTHUS |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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 | mack | 2006-06-26 20:10:07 | Re: Aborting transactions |
| Previous Message | Carlos H. Reimer | 2006-06-26 17:39:40 | Hiding table structure information |