grant under sql92

From: Vladislav Breus <vlad(at)dtr(dot)donetsk(dot)ua>
To: pgsql-sql(at)postgresql(dot)org
Subject: grant under sql92
Date: 2001-03-20 14:09:23
Message-ID: 3AB76493.EA2F87CF@dtr.donetsk.ua
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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.

Where I was wrong ?
Please, help me.

from aw_pgsql_book:
>The SQL92 syntax for GRANT allows setting privileges for individual columns within a table, and
>allows setting a privilege to grant the same privileges to others:
>GRANT privilege [, ...]
>ON object [ ( column [, ...] ) ] [, ...]
^^^^^^^^^^^^^^^^^^^^^
>TO { PUBLIC | username [, ...] }
>[ WITH GRANT OPTION ]

by default, I can use SQL92 format - is it right??

Browse pgsql-sql by date

  From Date Subject
Next Message Josh Berkus 2001-03-20 15:44:23 Re: Categories and subcategories
Previous Message juerg.rietmann 2001-03-20 12:50:32 postmaster not starting on my MS WIN NT