Postgres Pro
Downloads
Home   >   mailing lists

Re: Permissions + Views + Functions = relation not exist when not owner - Mailing list pgsql-sql

From Tom Lane
Subject Re: Permissions + Views + Functions = relation not exist when not owner
Date
Msg-id 11686.1117029511@sss.pgh.pa.us
Whole thread Raw
In response to Permissions + Views + Functions = relation not exist when not owner  ("Adie" <adie_xp@klub.chip.pl>)
List pgsql-sql
Tree view 
"Adie" <adie_xp@klub.chip.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

pgsql-sql by date:

Previous
From: "Adie"
Date:
Subject: Permissions + Views + Functions = relation not exist when not owner
Next
From: "hatuan"
Date:
Subject: Sql select like question.