column privileges
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.
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
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