Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtp (Exim 4.84_2)
	(envelope-from
 <pgsql-sql-owner+M39190=pgsql+2Dsql=arkaria.postgresql.org@postgresql.org>)
	id 1dHze6-00075c-9K
	for pgsql-sql@arkaria.postgresql.org; Mon, 05 Jun 2017 21:34:42 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
	by malur.postgresql.org with smtp (Exim 4.84_2)
	(envelope-from
 <pgsql-sql-owner+M39190=pgsql+2Dsql=arkaria.postgresql.org@postgresql.org>)
	id 1dHze5-0007zM-Nm
	for pgsql-sql@arkaria.postgresql.org; Mon, 05 Jun 2017 21:34:41 +0000
Received: from makus.postgresql.org ([2001:4800:1501:1::229])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.84_2)
	(envelope-from <anand086@gmail.com>)
	id 1dHze5-0007zC-6P
	for pgsql-sql@postgresql.org; Mon, 05 Jun 2017 21:34:41 +0000
Received: from mwork.nabble.com ([162.253.133.43])
	by makus.postgresql.org with esmtp (Exim 4.84_2)
	(envelope-from <anand086@gmail.com>)
	id 1dHze2-0005DO-B3
	for pgsql-sql@postgresql.org; Mon, 05 Jun 2017 21:34:39 +0000
Received: from mben.nabble.com (unknown [162.253.133.72])
	by mwork.nabble.com (Postfix) with ESMTP id C2A2A479AC5F1
	for <pgsql-sql@postgresql.org>; Mon,  5 Jun 2017 14:34:37 -0700 (MST)
Date: Mon, 5 Jun 2017 14:34:37 -0700 (MST)
From: anand086 <anand086@gmail.com>
To: pgsql-sql@postgresql.org
Message-ID: <1496698477794-5964888.post@n3.nabble.com>
In-Reply-To: <987.1496697317@sss.pgh.pa.us>
References: <1496695493471-5964882.post@n3.nabble.com>
 <987.1496697317@sss.pgh.pa.us>
Subject: Re: Delete failing with -- permission denied
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Pg-Spam-Score: -0.1 (/)
List-Archive: <http://archives.postgresql.org/pgsql-sql>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-sql.postgresql.org>
List-Owner: <mailto:pgsql-sql-owner@postgresql.org>
List-Post: <mailto:pgsql-sql@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-sql>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-sql>
X-Mailing-List: pgsql-sql
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

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.


-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql