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)