Postgres Pro
Downloads
Home   >   mailing lists

Thread: column privileges

column privileges

From
"Tjibbe Rijpma"
Date:
In postgresql privileges on colums is not possible, but is there a reason why not?
 
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.
 
 
 

Re: column privileges

From
John DeSoi
Date:
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

Re: column privileges

From
Tom Lane
Date:
John DeSoi <desoi@pgedit.com> writes:
> 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?

There is/was someone working on it, but we've not seen results yet.
Check the pghackers archives.

            regards, tom lane