Re: Baffled by basic permission issue.

If you want to use a view, you need the permissions for it. Not for the underlying tables

Am 16. Juni 2021 22:56:17 MESZ schrieb Wells Oliver <wells(dot)oliver(at)gmail(dot)com>:
>I have a view that does this:
>
>create view stats.v
>select * from stats.t
>join alias.i ON t.id = i.id
>join alias.i2 ON t.id2 = i2.id;
>
>And when I do: SELECT * FROM stats.v I receive: *ERROR: permission
>denied
>for table i*
>
>However, if I paste the contents of the view as a query and run it
>manually, it works fine.
>
>I can also query alias.i as I please.
>
>The role I am using to connect has USAGE on both stats and alias, it
>also
>has SELECT on the table as well as the view.
>
>The only difference is that the view is owned by a different user than
>the
>tables, though the SELECT permissions are definitely granted.
>
>psql 13.2
>
>--
>Wells Oliver
>wells(dot)oliver(at)gmail(dot)com <wellsoliver(at)gmail(dot)com>

--
Holger Jakobs, Bergisch Gladbach
+49 178 9759012
- sent from mobile, therefore short -