Re: Unable to select a table as postgres user - Mailing list pgsql-general

From rajan
Subject Re: Unable to select a table as postgres user
Date
Msg-id 1446188216514-5872041.post@n5.nabble.com
Whole thread Raw
In response to Re: Unable to select a table as postgres user  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: Unable to select a table as postgres user  (Pavel Stehule <pavel.stehule@gmail.com>)
Re: Unable to select a table as postgres user  (Charles Clavadetscher <clavadetscher@swisspug.org>)
List pgsql-general
Yes. I agree that the superuser cannot be restricted with any access.

But my scenarios is, I am executing a function(VOLATILE SECURITY DEFINER)
using the superuser and it function fails with unable to select a particular
table.

At the same time, I am able to select the table as a superuser, by executing
select * from table_name;



--
View this message in context:
http://postgresql.nabble.com/Unable-to-select-a-table-as-postgres-user-tp5872036p5872041.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


pgsql-general by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: Unable to select a table as postgres user
Next
From: Pavel Stehule
Date:
Subject: Re: Unable to select a table as postgres user