Re: Unable to select a table as postgres user

From: rajan <vgmonnet(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Unable to select a table as postgres user
Date: 2015-10-30 06:56:56
Message-ID: 1446188216514-5872041.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2015-10-30 07:17:04 Re: Unable to select a table as postgres user
Previous Message Pavel Stehule 2015-10-30 06:19:56 Re: Unable to select a table as postgres user