From: Tom Lane <tgl@sss.pgh.pa.us>
To: Edwin UY <edwin.uy@gmail.com>
cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: GRANT USAGE ON SCHEMA
In-reply-to: 
 <CA+wokJ9ApXRPQPoppfsSj0htM_dwSqjQ_RoWXdGb3RqRUtcmmQ@mail.gmail.com>
References: 
 <CA+wokJ9ApXRPQPoppfsSj0htM_dwSqjQ_RoWXdGb3RqRUtcmmQ@mail.gmail.com>
Comments: In-reply-to Edwin UY <edwin.uy@gmail.com>
	message dated "Sun, 15 Jun 2025 10:08:41 +1200"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <49892.1749940144.1@sss.pgh.pa.us>
Date: Sat, 14 Jun 2025 18:29:04 -0400
Message-ID: <49893.1749940144@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/49893.1749940144%40sss.pgh.pa.us>
Precedence: bulk

Edwin UY <edwin.uy@gmail.com> writes:
> 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

No.  Schema USAGE is more or less like directory read permissions in
a file system: it lets you get to the contained objects.  You also
need appropriate permissions on the contained objects in order to
do anything with them.

			regards, tom lane