Privileges for read-only tables with sequence and foreign keys

Поиск
Список
Период
Сортировка
От gvim
Тема Privileges for read-only tables with sequence and foreign keys
Дата
Msg-id 4D495FC0.1030406@gmail.com
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Florian Weimer
Дата:
Сообщение: Re: Changing SHMMAX
Следующее
От: Bill Moran
Дата:
Сообщение: Re: Why does my DB size differ between Production and DR? (Postgres 8.4)