Yup. I read it and tired couple of ways but couldn't figured out how to specify column names. It gives me below error message and hence, I asked for the example.
GRANT { { SELECT | INSERT | UPDATE | REFERENCES } ( *column* [, ...] ) [,...] | ALL [ PRIVILEGES ] ( *column* [, ...] ) } ON [ TABLE ] *tablename* [, ...] TO { [ GROUP ] *rolename* | PUBLIC } [, ...] [ WITH GRANT OPTION ] techdb=# grant select(column['description']) ON techtable TO user1; ERROR: syntax error at or near "column" LINE 1: grant select(column['description']) ON techtable TO user1; ^ Thanks, Dipti. On Thu, Apr 8, 2010 at 4:13 PM, Michael Glaesemann <g...@seespotcode.net>wrote: > > On Apr 8, 2010, at 4:22 , dipti shah wrote: > > > Hi, from postgesql features list mentioned at > > http://www.postgresql.org/about/press/features84.html, I came to know > that > > it is possible to grant column level permissions. > > <snip/> > > > Could anyone please give me the example of how to grant column level > > permissions? Basically, I want to give permissions to set of > > users(user-group) to only couple of columns in my table. > > Have you reviewed the fine documentation? > <http://www.postgresql.org/docs/8.4/interactive/sql-grant.html> > > Michael Glaesemann > grzm seespotcode net > > > >