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 1s5JNe-004dvl-2v for pgsql-general@arkaria.postgresql.org; Fri, 10 May 2024 06:05:18 +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 1s5JNc-00CjQN-CY for pgsql-general@arkaria.postgresql.org; Fri, 10 May 2024 06:05:16 +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 1s5JNc-00CjQF-1e for pgsql-general@lists.postgresql.org; Fri, 10 May 2024 06:05:16 +0000 Received: from mail-qk1-x729.google.com ([2607:f8b0:4864:20::729]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1s5JNa-000I9H-3w for pgsql-general@lists.postgresql.org; Fri, 10 May 2024 06:05:15 +0000 Received: by mail-qk1-x729.google.com with SMTP id af79cd13be357-78ecd752a7cso113430585a.0 for ; Thu, 09 May 2024 23:05:13 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1715321113; x=1715925913; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=ua5dD9ZpJCha8vQut6d5wq+uQn/GOsHBo/nOX3aWhc4=; b=QF3kjfixFSFCbxMvECUILeJ6ZJKs7uw1AlPDUKvUIWdALkA3PSQgZ+V859RFkXNCSC df2RH0t81kdU5DjmQZ4Hp9rtLKY/K/QBqHPQxUr5t5erkaZhdCG840rtH02gz6hIf3Ik U7uUiXAbwFUBJ9QTxLbcW78jNjdQFGrW/JQe0knIGQq5N3/G1GLOe4+jyDuXhLrYRMrz JQN00NyHz/MQrDoIQkcXLO1hKsroGCaNCD5uJGPp/RUyvLFipqnCj8qdu01HQEr5tx4D xOn1rSVNGtFTXU3TBhosQgRAHqp3DOQgbkr8n/0gDszB/keavLGJT+ROtKxTuBkiri4Y Fk/Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1715321113; x=1715925913; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=ua5dD9ZpJCha8vQut6d5wq+uQn/GOsHBo/nOX3aWhc4=; b=jzwN3bYgjEdJnyu3E5fQhlGjLrAvfo5d1UKQtQsyj+yvQ3ySq7wAO/ZmjSh+zcCMWM H5qA60keL4EK53eVVWQ8XSxh1QT8IYz0AgzdVW0lofHb8E5ld94ansFca8dbnpdvsFAV x473ttpl/GFJiETZVXeUgfmNDdSnexeAVPL78QquyDGMy+YuZrZC3N9brEKv0q10BLFG zqKgjVc9gBrlqO6yzc13FVaLcz5SIeK/ZWLbd2GvJFxWXpUgL4PqEWf9VvUcvKkClq2u ylS30QTNfLI8sW8X/tbbtnuX8s2YTsUr85hj7+0BXBb05YzBTURGsRdg8wzMyJYupBFW seFA== X-Gm-Message-State: AOJu0YwOgIX2jxpxreVFaX4pxpkcSk/HuFPNk9ZYZit0HPiqh3sX1hff 0F5CfkcjpgoWgCy7oaw6nOqazX3HYaspG/VYcGRO4n4wYLS8oJw7NyzFGwTuCte1IqzhUB/BeEm 1Ow8QRQqonRfQ04aX4duoxGwnczU= X-Google-Smtp-Source: AGHT+IFzEeagbxHZmqv3YWaylLHaOPr5upHlht5B/b80pEJsTwtCgndeLJ2Dkw1IUJj2+cwa8b/g5CdsNDy12oUxlYY= X-Received: by 2002:a05:6214:a0f:b0:6a0:7d7f:dfe6 with SMTP id 6a1803df08f44-6a168278614mr10145826d6.65.1715321113097; Thu, 09 May 2024 23:05:13 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: yudhi s Date: Fri, 10 May 2024 11:35:02 +0530 Message-ID: Subject: Re: Question on roles and privileges To: Lok P Cc: pgsql-general Content-Type: multipart/alternative; boundary="0000000000009f3bd506181351fb" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000009f3bd506181351fb Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Fri, May 10, 2024 at 11:31=E2=80=AFAM Lok P wrote= : > For the initial installation the extensions may need superuser privileges= . > >> >> Thank you. Yes, I got it. For the initial installation for the extensions ,it will need super user privilege. But once that is done for the day to day use , does these extensions need any write/execute privileges or readonly privileges is enough? and if any readymade role available through with all these are catered? --0000000000009f3bd506181351fb Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable

On Fri, May 10, 2024 at 11:31=E2=80=AFAM = Lok P <loknath.73@gmail.com&= gt; wrote:
For the initial installation the extensions may need superuser = privileges.


= Thank you. Yes, I got it. For the initial installation for the extensions ,= it will need=C2=A0 super user privilege. But once that is done for the day = to day use , does these extensions need any write/execute privileges or rea= donly privileges is enough? and if any readymade role=C2=A0available throug= h with all these are catered?
--0000000000009f3bd506181351fb--