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 1sHqn4-00BCN2-Pa for pgsql-hackers@arkaria.postgresql.org; Thu, 13 Jun 2024 20:11:22 +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 1sHqn2-0078Mz-Jc for pgsql-hackers@arkaria.postgresql.org; Thu, 13 Jun 2024 20:11:21 +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 1sHqn2-0078MW-9o for pgsql-hackers@lists.postgresql.org; Thu, 13 Jun 2024 20:11:21 +0000 Received: from mail-il1-x136.google.com ([2607:f8b0:4864:20::136]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sHqn0-001AlW-QL for pgsql-hackers@postgresql.org; Thu, 13 Jun 2024 20:11:19 +0000 Received: by mail-il1-x136.google.com with SMTP id e9e14a558f8ab-3758fdbd2daso5332925ab.3 for ; Thu, 13 Jun 2024 13:11:18 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1718309478; x=1718914278; darn=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=A/XAM7FUTJ55nus9IvoHmeJBx7gTVmb1Lfoaqp0U77E=; b=SuA2UoQD1rVu6g65cnK2T+nPyZmEkV+RnDFzZXP8MuOlwEms68WHkAkx2zY2pJsXWT pCg1p2i2tmjTdrQ3D22h+/e+o8v4dbv8sPfe4sL6qN3+huCYFXUSVYMaRKmSrla7hPrR O6O6PMk+xSqTG4dQcgyXbh4SV9odV2SXP/x5v6PNu3Vwq8UnDb24OyGAD52hATeJUrof wfxsL0MgCrKj4Oh77EeW9/RDq0SwyvtPkWD3lDfo20LeuCGLBauj6uzHDjjxFqUpCQeu 76eJm9MdGsmpRjjzi+butoXejBh2QQc+fCXzptxcd08L80BieRSeJy2m4F5xqJMYRtrv SOeA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1718309478; x=1718914278; 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=A/XAM7FUTJ55nus9IvoHmeJBx7gTVmb1Lfoaqp0U77E=; b=Ogw+I4VMuc/LOPhyMV4/lkluA09gE59sGDzrvGNbmNoks2JM0kGzLx9tFXZcxFeflx Za3/ZLyQ4/hpxJB0z4jQPjlP+AkPuFh1PL2yFkvWKLRGlSmGi9/LLL9dw8Q+GYb/Eo2D RPBFQ0Ahq2Mgv+S1y+fsv5AtlAbSxdpAVKz5tU3KCvJi8BrDcdcZUmjupjaKWCLZfeKP Eq51hTfuZS5r/HvOWQK0+DkWnP7BvVUodfzWN/NszrHofKjzNJCXdyJsmmmBSs5di/vk 0YWQC7ru/8GPdiiRaglK/y3r8WpZzppLTYQAU/yr6qqYz7CJ9PrHRbNBA2LgJ+SjdsRC yZbA== X-Gm-Message-State: AOJu0Yz0en1850aJh75CgKmNhFoEE4nVuAOrPAN0QnJ3xwaiZ+7ZqAZJ nugjV+jxwy3WZriEL+6ifxAMshiwvLM2r6/XKuXe6JXSZjwxqffiJ3xefbd8 X-Google-Smtp-Source: AGHT+IG7DGCL4+rIwvuayR6KkADKVRxFw/5uhnTub76YL3/4XoAN0lY3Zg/nYeMdw52cfKMWD2jtGA== X-Received: by 2002:a05:6e02:1945:b0:375:a7ee:dffc with SMTP id e9e14a558f8ab-375e0e2debamr6408335ab.11.1718309477752; Thu, 13 Jun 2024 13:11:17 -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-375d8755284sm3800375ab.54.2024.06.13.13.11.17 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 13 Jun 2024 13:11:17 -0700 (PDT) Date: Thu, 13 Jun 2024 15:11:15 -0500 From: Nathan Bossart To: "David G. Johnston" Cc: pgsql-hackers@postgresql.org Subject: Re: improve predefined roles documentation Message-ID: References: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, Jun 13, 2024 at 01:05:33PM -0700, David G. Johnston wrote: > One of the main attributes for the GUCs is their category. If we want to > improve organization we'd need to assign categories first. We already > implicitly do so in the description section where we do group them together > and explain why - but it is all informal. But getting rid of those > groupings and descriptions and isolating each role so it can be linked to > more easily seems like a net loss in usability. What I had in mind is that we would retain these groupings. I agree that isolating roles like pg_read_all_data and pg_write_all_data would be no good. -- nathan