Re: Changed functionality from 14.3 to 15.3 - Mailing list pgsql-general

From Michael Corey
Subject Re: Changed functionality from 14.3 to 15.3
Date
Msg-id CAABu8T88Y5yBsh+jgxOADSsbT86fQSYMjyPzCfBzh6J8wgjzOA@mail.gmail.com
Whole thread Raw
In response to Re: Changed functionality from 14.3 to 15.3  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: Changed functionality from 14.3 to 15.3  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
David,

How can I check the default privileges?  

On Wed, Sep 20, 2023 at 5:24 PM David G. Johnston <david.g.johnston@gmail.com> wrote:
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.

David J.



--
Michael Corey

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Changed functionality from 14.3 to 15.3
Next
From: Michael Corey
Date:
Subject: Re: Changed functionality from 14.3 to 15.3