From: | Wells Oliver <wells(dot)oliver(at)gmail(dot)com> |
---|---|
To: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | Baffled by basic permission issue. |
Date: | 2021-06-16 20:56:17 |
Message-ID: | CAOC+FBV5TxsJ4CHTo60TYGDNU0Y1eM=XzrzHJNmSgpyFLdmqMg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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>
From | Date | Subject | |
---|---|---|---|
Next Message | Holger Jakobs | 2021-06-16 20:58:41 | Re: Baffled by basic permission issue. |
Previous Message | Vijaykumar Jain | 2021-06-16 19:33:01 | Re: How does vacuum full works if table is partitioned? |