Privileges for read-only tables with sequence and foreign keys - Mailing list pgsql-general

From gvim
Subject Privileges for read-only tables with sequence and foreign keys
Date
Msg-id 4D495FC0.1030406@gmail.com
Whole thread Raw
List pgsql-general
To allow read-only access, ie. SELECT, to a user on a table which has a SERIAL column as well as foreign key references
doI need to GRANT the user anything other than SELECT on the table and its corresponding sequence? As I understand,
USAGEis only required to modify the table or use the currval function while REFERENCES is only required to create a
foreignkey, not to make use of it. 

gvim

pgsql-general by date:

Previous
From: Florian Weimer
Date:
Subject: Re: Changing SHMMAX
Next
From: Bill Moran
Date:
Subject: Re: Why does my DB size differ between Production and DR? (Postgres 8.4)