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 some table/view? > > thank you > > Eddy > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
