Re: Permissions on columns: in todo list??

From: Darren Ferguson <darren(at)crystalballinc(dot)com>
To: Devrim GUNDUZ <devrim(at)oper(dot)metu(dot)edu(dot)tr>
Cc: PostgreSQL Mailing Lists-General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Permissions on columns: in todo list??
Date: 2002-04-12 19:05:40
Message-ID: Pine.LNX.4.10.10204121505280.9285-100000@thread.crystalballinc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)oper(dot)metu(dot)edu(dot)tr
> devrim(dot)gunduz(at)linux(dot)org(dot)tr
> devrimg(at)tr(dot)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(at)postgresql(dot)org)
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Justin Clift 2002-04-12 19:37:10 Binaries for Solaris
Previous Message Josh Berkus 2002-04-12 19:00:19 Proposal: New Mailing List