pg.ddx.io pgsql-sql@postgresql.org mailing list archivehelp / color / mirror / Atom feed
From: Vladislav Breus <vlad@dtr.donetsk.ua>
To: pgsql-sql@postgresql.org
Subject: grant under sql92
Date: Tue, 20 Mar 2001 16:09:23 +0200
Message-ID: <3AB76493.EA2F87CF@dtr.donetsk.ua> (raw)
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??
Message-ID: <3AB76493.EA2F87CF@dtr.donetsk.ua> Permalink: ../3AB76493.EA2F87CF@dtr.donetsk.ua/ Also on: postgresql.org/message-id/3AB76493.EA2F87CF@dtr.donetsk.ua ·
reply
Reply instructions: You may reply publicly to this message via plain-text email using any one of the following methods: * Reply to all the recipients from your mail client; the link fills in the headers below: reply via email Some clients, webmail especially, drop In-Reply-To and References from a link, and the reply then starts a new thread: use the mbox below. To: pgsql-sql@postgresql.org Cc: vlad@dtr.donetsk.ua Subject: Re: grant under sql92 In-Reply-To: <3AB76493.EA2F87CF@dtr.donetsk.ua> References: <3AB76493.EA2F87CF@dtr.donetsk.ua> * Save the following mbox file, import it into your mail client, and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox