On Thu, Apr 8, 2010 at 1:52 PM, dipti shah <shahdipti1980@xxxxxxxxx> 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@xxxxxxxxx FB: http://tinyurl.com/fbmbst MS: http://myspace.com/mpawlikowski -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
