Re: A question about PG Authorization

Eddy,

The command you need  is:
psql> grant update on table_name to username;

Banghe

Dong Meng wrote:

> Dear Guys,
>
> May I have a question about the authorization of psql?
>
> By using '\z' in psql context, I can get the description of authorization about each table/view.
>
>
>                   r -- SELECT
>                   w -- UPDATE/DELETE
>                   a -- INSERT
>                   R -- RULE
>                arwR -- ALL
>
> Authoriztion switches are specified as above, but what should I do if I want to grant 'update' without 'delete' to
sometable/view? 
>
> thank you
>
> Eddy
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html