On 2023-09-20 09:15 -0400, Michael Corey wrote: > Thanks for responding. All of the DDL is just the setup for the test > case. I ran those steps in both databases to setup the exact same > environment. And both databases start empty or at least in the exact same state? > The COMMIT is not needed for the test out of habit I put it > in my setup. The main issue is in 14.3 I can run this select as user > sten_schema, but in 15.3 I am unable due to a permission issue. I don't know why those privileges could be missing if that script completes. Please provide the privileges like I asked to see what's actually granted on both databases: > On Tue, Sep 19, 2023 at 8:17 PM Erik Wienhold <ewie@xxxxxxxxx> wrote: > > > > Have you checked that the permissions are actually the same on both > > databases after running that script? > > > > \dn+ ref_schema|sten_schema > > \dp ref_schema.ref_media_code > > \dp sten_schema.sten_media_codes_view -- Erik
