From: | Vladislav Breus <vlad(at)dtr(dot)donetsk(dot)ua> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | grant under SQL92 |
Date: | 2001-03-20 15:13:57 |
Message-ID: | 3AB773B5.7A669CB4@dtr.donetsk.ua |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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??
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff Eckermann | 2001-03-20 15:27:17 | RE: Strange Type Mismatch on Insert |
Previous Message | Gilles DAROLD | 2001-03-20 15:12:39 | Re: postgreSQL db temporary on Microsoft IIS 4.0 |