Baffled by basic permission issue.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

--

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux