Postgres Pro
Downloads
Home   >   mailing lists

A question about PG Authorization - Mailing list pgsql-admin

From Dong Meng
Subject A question about PG Authorization
Date
Msg-id AEEBJOIDAHEOMKHEOGEIOEHICEAA.eddy@securities.com
Whole thread Raw
In response to Re: HELP: language option software package not installed  (Randall Shutt <randall@cscc.net>)
Responses Re: A question about PG Authorization
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Any body know --- 'sql query where condition execution plan'
Next
From: Andre Schubert
Date:
Subject: Re: Subselects and Indices