Postgres Pro
Downloads
Home   >   mailing lists

Thread: column-level privilege

column-level privilege

From
"jkzhao"
Date:
Dear hackers,
 
    I am a PostgreSQL lover at China, I'd like to know when the column-level privilege can be added to a release version of PostgreSQL? and is there someone who is working on the problem?
 
    Thanks & Best Regards.
 
jkzhao
2006-07-25

Re: column-level privilege

From
Peter Eisentraut
Date:
Am Dienstag, 25. Juli 2006 09:13 schrieb jkzhao:
>     I am a PostgreSQL lover at China, I'd like to know when the
> column-level privilege can be added to a release version of PostgreSQL? and
> is there someone who is working on the problem?

It would certainly be a welcome feature, but there are no concrete plans for 
it yet.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/

Re: column-level privilege

From
Tom Lane
Date:
Peter Eisentraut <peter_e@gmx.net> writes:
> Am Dienstag, 25. Juli 2006 09:13 schrieb jkzhao:
>> I am a PostgreSQL lover at China, I'd like to know when the
>> column-level privilege can be added to a release version of PostgreSQL? and
>> is there someone who is working on the problem?

> It would certainly be a welcome feature, but there are no concrete plans for 
> it yet.

There was someone fooling with it awhile ago, but we've not heard from
him lately --- IIRC he was last seen trying to deal with the fact that
parts of the system assume pg_attribute tuples are fixed-width.  Check
the archives.
        regards, tom lane

Re: column-level privilege

From
"Andrew Hammond"
Date:
>     I am a PostgreSQL lover at China, I'd like to know when the column-level privilege can be added to a release
versionof PostgreSQL? and is there someone who is working on the problem?
 

You can often achieve similar effects with VIEWs and RULEs / TRIGGERs.

Drew