Postgresql \z grant question - Mailing list pgsql-admin

From hicham bouzdad
Subject Postgresql \z grant question
Date
Msg-id 3AA75C8B.508E184E@inovaction.com
Whole thread Raw
In response to Re: Postgresql \z grant question  ("Oliver Elphick" <olly@lfix.co.uk>)
List pgsql-admin
Hi everyone,  and thanks a lot ,

> PostgreSQL access permissions are not yet as extensive as the full SQL
> spec requires.

> 'w' includes UPDATE and DELETE;
>  there is no finer-grained permission  available.


if i do  on   (PostgreSQL 7.1beta4 ) :
      GRANT  UPDATE ON  tabl TO  user;

user can  do  on  tabl  :
      UPDATE,  but also   DELETE and  INSERT  !


my question is :
     can i bypass this  limitation ?




pgsql-admin by date:

Previous
From: Rick Robino
Date:
Subject: Re: Python, Postgres support?
Next
From: Stephan Szabo
Date:
Subject: Re: Using psql