Re: column privileges

From: John DeSoi <desoi(at)pgedit(dot)com>
To: Tjibbe Rijpma <tjibbe(at)hotmail(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: column privileges
Date: 2006-10-09 14:10:07
Message-ID: E7E8F700-D540-4185-9C06-0A4C956C1D05@pgedit.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Oct 9, 2006, at 5:51 AM, Tjibbe Rijpma wrote:

> In postgresql privileges on colums is not possible, but is there a
> reason why not?

No one has volunteered to implement it? I don't think it is a
technical reason.

>
> For my application I want the option to hide some columns for some
> users. So I use functions that make views for each user. Another
> solution may be to make a new table with a foreign key and an 1 to
> 1 relation. Maybe an answer from the question above can help me to
> descide.

You might find this helpful:

http://veil.projects.postgresql.org/curdocs/main.html

John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2006-10-09 14:28:04 Re: column privileges
Previous Message Michael Fuhr 2006-10-09 13:54:11 Re: PL/SQL: function call like $1($2)