Re: [SQL] Delete failing with -- permission denied

Поиск
Список
Период
Сортировка
От anand086
Тема Re: [SQL] Delete failing with -- permission denied
Дата
Msg-id 1496698477794-5964888.post@n3.nabble.com
обсуждение исходный текст
Ответ на Re: [SQL] Delete failing with -- permission denied  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: [SQL] Delete failing with -- permission denied  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-sql
Thank you Tom for your quick reply.


"FK CASCADE queries are run as the owner of the table in question."

All the table belong to TEST and application user is user_test. Below grants
were granted to "user_test"

GRANT ALL PRIVILEGES ON ALL TABLES IN schema "test"  TO user_test;
grant usage on schema "test" to user_test;

What would be needed to rectify the issue?






--
View this message in context:
http://www.postgresql-archive.org/Delete-failing-with-permission-denied-tp5964882p5964888.html
Sent from the PostgreSQL - sql mailing list archive at Nabble.com.



В списке pgsql-sql по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [SQL] Delete failing with -- permission denied
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: [SQL] Delete failing with -- permission denied