public inbox for [email protected]  

help / color / mirror / Atom feed

From: Edwin UY <[email protected]>
To: Pgsql-admin <[email protected]>
Subject: GRANT USAGE ON SCHEMA
Date: Sun, 15 Jun 2025 10:08:41 +1200
Message-ID: <CA+wokJ9ApXRPQPoppfsSj0htM_dwSqjQ_RoWXdGb3RqRUtcmmQ@mail.gmail.com> (raw)

Hi,

Just playing around here trying and 'confused' what the GRANT USAGE ON
SCHEMA is supposed to be for?
I thought it was supposed to all 'full' access of one schema to the other

I have created 2 schema a, b and I did

grant usage on schema a to b
grant usage on schema b to a

I tried to select tables from one to the other and it is giving permission
denied until I have to do the grant below.

grant all on all tables in schema a to b ;
grant all on all tables in schema b to a ;

Is this expected behavior? Or does the GRANT USAGE only allows
switching between schema?

Regards,
Edd

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]
  Subject: Re: GRANT USAGE ON SCHEMA
  In-Reply-To: <CA+wokJ9ApXRPQPoppfsSj0htM_dwSqjQ_RoWXdGb3RqRUtcmmQ@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