Обсуждение: 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