Обсуждение: Privileges for read-only tables with sequence and foreign keys

Поиск
Список
Период
Сортировка

Privileges for read-only tables with sequence and foreign keys

От
gvim
Дата:
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