Re: Permissions + Views + Functions = relation not exist when not owner

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Adie" <adie_xp(at)klub(dot)chip(dot)pl>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Permissions + Views + Functions = relation not exist when not owner
Date: 2005-05-25 13:58:31
Message-ID: 11686.1117029511@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"Adie" <adie_xp(at)klub(dot)chip(dot)pl> writes:
> I got a View which calls function which uses table.
> It works fine when selecting from view by owner (postgres) of table,
> function and view.
> Problem is when another user is sellecting view. There is an error:
> ERROR: relation "XXX" does not exist

Perhaps the other user is running with a different search_path setting?

regards, tom lane

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message hatuan 2005-05-25 15:28:00 Sql select like question.
Previous Message e-mail rassylka 2005-05-25 13:39:44 e-mail рассылки