Use views instead and then set the permissions on the view
Darren Ferguson
On Fri, 12 Apr 2002, Devrim GUNDUZ wrote:
>
> Hi,
>
> Will PostgreSQL be able to limit access on colums as well as tables?
>
> Say we have a table foo having columns a,b,c.
> GRANT UPDATE ON foo(a) to devrim;
>
> Will that be possible as it is on Oracle?
>
> Best regards,
>
> --
>
> Devrim GUNDUZ
>
> devrim@oper.metu.edu.tr
> devrim.gunduz@linux.org.tr
> devrimg@tr.net
>
> Web : http://devrim.oper.metu.edu.tr
> ------------------------------------------------------------------
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>