On 11/13/2017 09:09 PM, Andrea Adami wrote:
> As suggested from Joe i changed the db definition as enclosed.
> Now when i do:
>
> select * fom schools
>
> all works fine
>
> but when i do:
[SELECT from VIEW]
> always i get the error:
>
> permission denied for relation schools
> SQL state: 42501
>
> Someone has some suggestion ?
Offhand I would say you probably need to GRANT ALL (or SELECT or
whatever needed) to the VIEW owner.
Joe
--
Crunchy Data - http://crunchydata.com
PostgreSQL Support for Secure Enterprises
Consulting, Training, & Open Source Development