Re: Postgresql \z grant question

I believe the only thing you can do is revoke the INSERT permission (after
granting UPDATE), but I don think you can revoke the DELETE permission
since is the same flag as UPDATE.


hicham bouzdad wrote:

> 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 ?
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)