Re: Grant column level permissions - Mailing list pgsql-general

From Michał Pawlikowski
Subject Re: Grant column level permissions
Date
Msg-id z2v217ea9ed1004080458lc1df6b63xa7c4f9f098015fba@mail.gmail.com
Whole thread Raw
In response to Re: Grant column level permissions  (dipti shah <shahdipti1980@gmail.com>)
List pgsql-general
On Thu, Apr 8, 2010 at 1:52 PM, dipti shah <shahdipti1980@gmail.com> wrote:
> techdb=> select * from techtable;
> ERROR:  permission denied for relation techtable
> techdb=>
>
> ...and it gives permission denied..!

This should work:
SELECT description from techtable;
UPDATE techtable SET description = 'xyz'

This should not work:
select * from techtable;
UPDATE techtable SET other_column = 'xyz'

--
Pozdrawiam / Best Regards / Mit freundlichen Grüßen
Michal Pawlikowski
XMPP: misiekbest@gmail.com
FB: http://tinyurl.com/fbmbst
MS: http://myspace.com/mpawlikowski

pgsql-general by date:

Previous
From: dipti shah
Date:
Subject: Re: Grant column level permissions
Next
From: Craig Ringer
Date:
Subject: Re: Extending PostGreSQL/PostGIS with an abstract data type.