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
signature.asc
Description: OpenPGP digital signature
