public inbox for [email protected]  

help / color / mirror / Atom feed

From: Edwin UY <[email protected]>
To: David G. Johnston <[email protected]>
Cc: Pgsql-admin <[email protected]>
Subject: Re: GRANT USAGE ON SCHEMA
Date: Sun, 15 Jun 2025 22:06:11 +1200
Message-ID: <CA+wokJ_kPqs0RmKo3gFurJnb4P2zVe2_oA8b_RU7kHgughFfRw@mail.gmail.com> (raw)
In-Reply-To: <CAKFQuwY8+JZe1KDh25LrqxbKNe-sVp265K5vFdzMXG1EHOcmhw@mail.gmail.com>
References: <CA+wokJ9ApXRPQPoppfsSj0htM_dwSqjQ_RoWXdGb3RqRUtcmmQ@mail.gmail.com>
	<CAKFQuwY8+JZe1KDh25LrqxbKNe-sVp265K5vFdzMXG1EHOcmhw@mail.gmail.com>

Hi David J,

Yeah, sorry, I should have used different names, but yeah, I have also
created the a and b roles named the same as the schema.
Should have used schema_a, schema_b, role_a, role_b.



On Sun, Jun 15, 2025 at 11:19 AM David G. Johnston <
[email protected]> wrote:

> On Sat, Jun 14, 2025 at 3:09 PM Edwin UY <[email protected]> wrote:
>
>> I thought it was supposed to all 'full' access of one schema to the other
>>
>
> Where did you get the idea that objects (aside from roles) ever get
> privileges on other objects?  Or did you also create roles "a" and "b" and
> are just using the wrong terminology here?
>
> There is also no such thing as permissions on one type of object somehow
> affecting your privileges on other object types.  Your privileges on
> schemas will not influence (directly) your permissions on tables.  Neither
> to grant additional privileges or to block them - say if you don't have
> usage on schema but do have select on a contained table.  Corner-cases that
> do behave this way notwithstanding - it isn't reliable.
>
> David J.
>
>

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: GRANT USAGE ON SCHEMA
  In-Reply-To: <CA+wokJ_kPqs0RmKo3gFurJnb4P2zVe2_oA8b_RU7kHgughFfRw@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox