From: | Michał Pawlikowski <misiekbest(at)gmail(dot)com> |
---|---|
To: | dipti shah <shahdipti1980(at)gmail(dot)com> |
Cc: | Michael Glaesemann <grzm(at)seespotcode(dot)net>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Grant column level permissions |
Date: | 2010-04-08 11:58:11 |
Message-ID: | z2v217ea9ed1004080458lc1df6b63xa7c4f9f098015fba@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Thu, Apr 8, 2010 at 1:52 PM, dipti shah <shahdipti1980(at)gmail(dot)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(at)gmail(dot)com
FB: http://tinyurl.com/fbmbst
MS: http://myspace.com/mpawlikowski
From | Date | Subject | |
---|---|---|---|
Next Message | Craig Ringer | 2010-04-08 12:11:10 | Re: Extending PostGreSQL/PostGIS with an abstract data type. |
Previous Message | dipti shah | 2010-04-08 11:55:50 | Re: Grant column level permissions |