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 1sQdwt-00Atbn-7f for pgsql-hackers@arkaria.postgresql.org; Mon, 08 Jul 2024 02:17:51 +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 1sQdwr-00HV9b-WE for pgsql-hackers@arkaria.postgresql.org; Mon, 08 Jul 2024 02:17:50 +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 1sQdwr-00HV9T-MZ for pgsql-hackers@lists.postgresql.org; Mon, 08 Jul 2024 02:17:49 +0000 Received: from mail-il1-x134.google.com ([2607:f8b0:4864:20::134]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sQdwp-000wNg-Bz for pgsql-hackers@lists.postgresql.org; Mon, 08 Jul 2024 02:17:48 +0000 Received: by mail-il1-x134.google.com with SMTP id e9e14a558f8ab-383dfcd8cdfso16215485ab.1 for ; Sun, 07 Jul 2024 19:17:47 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1720405066; x=1721009866; darn=lists.postgresql.org; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:from:to:cc:subject:date:message-id:reply-to; bh=p4X0Hqiuk3PyN6PUeQSxEMqTtRU3FPej5xC3XQM2rR0=; b=I/6tiiHe5SxIGH2XKuhpYxelUedG5VQSQYm1EeZ2mQKJtGpVZXgJCl3nJnlHNwQP3E N2TeYWNKTzZ8Xm55irwzIhgKZD5ZncFBgECDvtmpaD/o9nRafeSNkit0r674/KpB9iKU v2/qeybuQlXH8rj7VQMC1EHissMITL3DCAnZ/KxJBwBgnQpuXTEyYtFukRp4oPqs0nZq NfWF2QCBSz+zNx9NePYlg/K3nPyC/KO5iLyNxqVrAcpxZJ7AZfdNLmq6RgQLCNskpKn4 Zuy9oSp8HWuPp/2/iRqtXoj3IsufjdUQDxxDNSVpOtoi1e79skGDVmFsylKk0tutRnFU wdyg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1720405066; x=1721009866; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=p4X0Hqiuk3PyN6PUeQSxEMqTtRU3FPej5xC3XQM2rR0=; b=kRyIXc7Bv1WL+4OPX1jWXS/DbHxi8Rwn2LBbyPdvsPJH0NHnBKBhRrk3/Mz+NF+Ek2 dTuu6ij1ZMP9giOcGGSMh03qCL5Qf8PkcuKP1CNdVj8d6ekVjNl98UOGfpyEunGiJdAl UbrnabLbceDcxIBsgCJWTgrP5i323T3ss9NW/kvTk0akKktOO+5AkyYX9K1rj8fgiTgn asz3xkjCU5S7BSmNtuvPNVArj2gwPy0vcIA6Y4bqU7qlLpOB+9gYjaNaLdNK/wrFcS+t ziRyUF9JPHkNyb4zrs0eRCNwYGQzXXdm/aqP4ZaHa648xNGLZpLAcxAjvTyNamgg/Vwx js9A== X-Gm-Message-State: AOJu0Yz0J4KnJnmKaJOHeDngH2qO75an9v9h4b/pYSCmt+u4Zea62Wv7 nZU3ffl2AJ7nTfw1pkQcyQngQAh7xM5uMypB9bGEIl2sHnuyMk5Z X-Google-Smtp-Source: AGHT+IFSF5KKJjU08c9Q4UsZZXDF/fmABhIxkQPYfVNV6Uhzw6H0tj+vAaOJzG07LG2iEIIfcmzJsg== X-Received: by 2002:a05:6e02:1c08:b0:375:aaaf:e88f with SMTP id e9e14a558f8ab-3839adb356emr153977765ab.27.1720405066533; Sun, 07 Jul 2024 19:17:46 -0700 (PDT) Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id e9e14a558f8ab-3842bd87e96sm18859065ab.54.2024.07.07.19.17.46 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Sun, 07 Jul 2024 19:17:46 -0700 (PDT) Date: Sun, 7 Jul 2024 21:17:44 -0500 From: Nathan Bossart To: Fujii Masao Cc: PostgreSQL Developers Subject: Re: pg_maintain and USAGE privilege on schema Message-ID: References: <56596b81-088f-4c0c-9a88-b5f27a7a62e9@oss.nttdata.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <56596b81-088f-4c0c-9a88-b5f27a7a62e9@oss.nttdata.com> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, Jul 08, 2024 at 01:03:42AM +0900, Fujii Masao wrote: > If this has already been discussed and the current behavior is deemed proper, > I'm sorry for bringing it up again. Even in that case, it would be helpful > to document that USAGE privilege on the schema may be necessary in addition > to pg_maintain to perform the maintenance command. If we don't proceed with the implicit-USAGE-privilege idea, +1 for documenting. -- nathan