Re: [GENERAL] grant under SQL92

2001-03-20 Thread Oliver Elphick
Vladislav Breus wrote: >test=> create table test (col1 int,col2 int); >test=> grant select on test (col1) to user1; >ERROR: parser: parse error at or near "(" > > >I'm trying to use GRANT with SQL92 extentions,(set permissions on >the individual column) but it dosn't work. > >Whe

[GENERAL] grant under SQL92

2001-03-20 Thread Vladislav Breus
I have postgresql-7.0.3 I'm trying to do following : test=> create table test (col1 int,col2 int); test=> grant select on test (col1) to user1; ERROR: parser: parse error at or near "(" I'm trying to use GRANT with SQL92 extentions,(set permissions on the individual column) but it dosn't work