Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1p46er-0008Q0-R2 for pgsql-hackers@arkaria.postgresql.org; Sat, 10 Dec 2022 20:41:17 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1p46ep-00085b-PX for pgsql-hackers@arkaria.postgresql.org; Sat, 10 Dec 2022 20:41:15 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1p46ep-00085S-A5 for pgsql-hackers@lists.postgresql.org; Sat, 10 Dec 2022 20:41:15 +0000 Received: from mail-pj1-x102a.google.com ([2607:f8b0:4864:20::102a]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1p46en-0001Kd-50 for pgsql-hackers@postgresql.org; Sat, 10 Dec 2022 20:41:14 +0000 Received: by mail-pj1-x102a.google.com with SMTP id q17-20020a17090aa01100b002194cba32e9so11672775pjp.1 for ; Sat, 10 Dec 2022 12:41:12 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; 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=/7rc1cAaDcO/eeAawg7cVx3voDCD2uggAH96sGODDjA=; b=AqvgMxTOHMJuWx71vEg+qzcLPjDeZbRFPoMuTXW38NZ80Q2ujwXM1Fd3qTy+8Up9px 13b6e6q+Mx1HAzTq82Fn5Vm2YPCcg6R5jAD2l3gxxEaPr1LWer7c3G0RRUyencDptqtI JYXOnO4S8L+W3LM1hs6sSLQBXIs9lvZh2f/5HSwntcvLWSGqiYkKNCPns/eI89S48zep 7QsmyuZfGMRAFcaD32PgDRkED2JnfaeXqcrnVp6TI34M6RiWm1zMWYV+zfkOQ7J+LbGg AJ3fiEFv7qd//qd5gQZuyCpv+XyylJHkPEP1Gayevg2ouAyREQvjGwsqtZNiXS9b/KST lSoQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; 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=/7rc1cAaDcO/eeAawg7cVx3voDCD2uggAH96sGODDjA=; b=Pw30Ia5ZspIsS+kUKYC8ON5b7kOrbX/+QAhiEZoHPbQjcETMU+5YHeBYqBB86tYtq6 bS6ZZx8FZuarr/w/aLFLpHH2htCP7ZteR1IM5vyOe9bgnyYDy/br5lT2IWwamji+5mJ7 pAmPxA7s2FFSpOS0gTyXS/4/RX2sAei/VlSWPj/5H4zZutLUiW2LgwqmVTroclQlIa15 Iw1xIbtOT17sYX5fP9mHkoq2klVNKipkMQlr0ntbySg91TV/m5ET47qk/H2CPIE0CAf5 B+UXQoajUPU57YP+enPXgdRTnceLXmkOK9IqIt+2JSU4aVkqccch2EuSplBSQL6UfL7/ Q61g== X-Gm-Message-State: ANoB5pk9hcdHWDZRsDo5bzGbxkSINbgjwiSK3Nbgm/EbyDo6DGqwpVQx L/NUv5HzcFiGxAtauErd1Lc= X-Google-Smtp-Source: AA0mqf7s8sSMUBise4UaS6+pyQuZh5MWZEnqz7r0hABnHQWsnaCkB6yDy2ffwjYRj20FLwQBND/pTQ== X-Received: by 2002:a17:902:8605:b0:186:5fa1:1eae with SMTP id f5-20020a170902860500b001865fa11eaemr9231059plo.48.1670704871779; Sat, 10 Dec 2022 12:41:11 -0800 (PST) Received: from nathanxps13 ([50.47.162.83]) by smtp.gmail.com with ESMTPSA id a4-20020a170902ecc400b0017f8094a52asm3355507plh.29.2022.12.10.12.41.10 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Sat, 10 Dec 2022 12:41:11 -0800 (PST) Date: Sat, 10 Dec 2022 12:41:09 -0800 From: Nathan Bossart To: Jeff Davis Cc: pgsql-hackers@postgresql.org Subject: Re: allow granting CLUSTER, REFRESH MATERIALIZED VIEW, and REINDEX Message-ID: <20221210204109.GA197392@nathanxps13> References: <20221208183707.GA55474@nathanxps13> <210dc2cc663934f8b463e4effa9af86225e46ce4.camel@j-davis.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <210dc2cc663934f8b463e4effa9af86225e46ce4.camel@j-davis.com> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Sat, Dec 10, 2022 at 12:07:12PM -0800, Jeff Davis wrote: > It seems like the discussion on VACUUM/CLUSTER/REINDEX privileges is > happening in the other thread. What would you like to accomplish in > this thread? Given the feedback in the other thread [0], I was planning to rewrite this patch to create a MAINTAIN privilege and a pg_maintain_all_tables predefined role that allowed VACUUM, ANALYZE, CLUSTER, REFRESH MATERIALIZED VIEW, and REINDEX. [0] https://postgr.es/m/20221206193606.GB3078082%40nathanxps13 -- Nathan Bossart Amazon Web Services: https://aws.amazon.com