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.