Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uQZ41-00DSxi-9Y for pgsql-admin@arkaria.postgresql.org; Sat, 14 Jun 2025 22:09:25 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1uQZ3x-00AIKj-E9 for pgsql-admin@arkaria.postgresql.org; Sat, 14 Jun 2025 22:09:22 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uQZ3w-00AIKa-Ub for pgsql-admin@lists.postgresql.org; Sat, 14 Jun 2025 22:09:21 +0000 Received: from mail-pj1-x1031.google.com ([2607:f8b0:4864:20::1031]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uQZ3v-0021QK-2P for pgsql-admin@lists.postgresql.org; Sat, 14 Jun 2025 22:09:20 +0000 Received: by mail-pj1-x1031.google.com with SMTP id 98e67ed59e1d1-311da0bef4aso3718267a91.3 for ; Sat, 14 Jun 2025 15:09:19 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1749938958; x=1750543758; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=TiefpGvHWXoOB08x22wrT7uduKf6UiaLm7hRcnVh8CE=; b=IyHQJdFXPJa540zHYD161NxrUIwjwP4lGKw426H6DVJP7ZMql4qc8F6qHoLZaLDhxr gzgNLfDl/S7BAxSz9Yoh0258x0rLcf58Oq7xfCgOfVOYZ3B0z8EeSDI6ua5XWGiQzD30 W8LnlMunidZW5S/d+rFxX9BtLX6UgKPfvtyuCccFO7XA1DtuPArimDwKkbwOb+VosAuL PH10vrfoVPcRj/y3D5IC6+QzYrwwfAlDhHge/DiHKyJjrVxbFywLclJkt7HrC5TWu/0T KVSE0oBbK1AOV5ae5zcV2m4A4ih6HvDDsNuaU9rvxinawpzUS2VPhpSBvc/mzm30a7fT w0Kw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1749938958; x=1750543758; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=TiefpGvHWXoOB08x22wrT7uduKf6UiaLm7hRcnVh8CE=; b=dEx9orTYi8ZJVDxw9CgECTJ4EyuMxgHwsTLFWv7hvnzfsqRY/jCtlJtLT1uNDzN2c1 OGzxHwPW/OM/DTDLKuGjRzAzPpiQJj7RbMxCdR+exlc07DZ2WOGyHlTNfgbhNmc2b7VD RTnMXjm68YXvjcIujie3w+xrtEG5aehp02p1yr+w+Gw10cuS9hpL3zoYNNxcpa3QRqs2 /QY8mnsqFkQZw8Nduey7Dc7pf6PgSZvtT0K+8tTsRinJBvt0DmToazK64VUi3+DMbd9P 0KcQwL7BQto4ytLOVK5ecTBsa16rl8f9qx4kroLp7H5Yg5Uk3H26RIh2ZerRD19no/Xh 9yyg== X-Gm-Message-State: AOJu0YxTCD4RJw9S+LgYsaBhbFl0iSD0b4zSGFv2h1GOrERxRKlN/tZi meogbl/02cEh8824vutkOlnMZzWhGxbybSWiLFvtl777lY5FVn0ObCjVnmXXUiJS5wvWcYRA9hJ FvFPCwwolSo0S8RUQHPwjAXwu7BDlkrHp6Q0kqMiuVA== X-Gm-Gg: ASbGnctSWy7GfnfnQ6bf7unZvd0LpnP/F8Bjr2MCsTQh0rfTsSp+17co8XQ5TKEkqiO j9SgxtoL412xx8PVitVviN0RdcTdbjTwbc/Xd/RytHQ6ngBLVTj5/zo3XHUCOlRZoNuND9nfjCP 0C8UoV2bJjIGdWwi2RUHi8kG6B/m2XIPZ2naOm+csiT0A= X-Google-Smtp-Source: AGHT+IHFCJ5hx01h9LPLX7Wg6gBFUzubGxzp46Ui86xrm9Fj4s+p7ItIqRCQmICy2pqiSeo+o38ZECrC2GmNtskkgOo= X-Received: by 2002:a17:90b:582f:b0:313:bf67:b354 with SMTP id 98e67ed59e1d1-313f1b87a40mr8111061a91.0.1749938957636; Sat, 14 Jun 2025 15:09:17 -0700 (PDT) MIME-Version: 1.0 From: Edwin UY Date: Sun, 15 Jun 2025 10:08:41 +1200 X-Gm-Features: AX0GCFuBNfknMT3WLdTw3cONOVv5oizObd192YkleQALEAPT1FUc713NdydqvZ0 Message-ID: Subject: GRANT USAGE ON SCHEMA To: Pgsql-admin Content-Type: multipart/alternative; boundary="000000000000f2dac706378f6965" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000f2dac706378f6965 Content-Type: text/plain; charset="UTF-8" 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 --000000000000f2dac706378f6965 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi,

Just playing around here trying and 'confu= sed' what the GRANT USAGE ON SCHEMA is supposed to be for?
=
I thought it was supposed=C2=A0t= o 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
<= div>
I tried to select=C2=A0tables from one to the ot= her and it is giving permission denied until I have to do the grant below. =

grant all on all tables in sch= ema a to b ;
grant all on a= ll tables in schema b to a ;

Is thi= s expected behavior? Or does the GRANT USAGE only allows switching=C2=A0bet= ween schema?

Regards,
<= div>Edd
--000000000000f2dac706378f6965--