On Wed, Sep 20, 2023 at 2:20 PM Erik Wienhold <ewie@ewie.name> wrote:
Has your 14.3 some left-over state from previous test runs? I assume the server is not re-created for each test run. I was wondering if the roles may still exist and with additional memberships. But then again the script just uses CREATE ROLE. So the roles definitely do not exist beforehand. But what are the actual memberships of sten_schema? Because it must inherit SELECT on ref_media_code on 14.3. It can't be from object_creator because that role also gets newly created.
Your description also suggests that maybe the v14 instance has altered default privileges setup that maybe the v15 doesn't have.