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 1s6tzK-002NFD-1H for pgsql-general@arkaria.postgresql.org; Tue, 14 May 2024 15:22:47 +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 1s6tzJ-00G6pQ-Li for pgsql-general@arkaria.postgresql.org; Tue, 14 May 2024 15:22:45 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s6n2y-00BCkG-AP for pgsql-general@lists.postgresql.org; Tue, 14 May 2024 07:58:04 +0000 Received: from mail-pg1-x52a.google.com ([2607:f8b0:4864:20::52a]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1s6n2u-0009iC-W2 for pgsql-general@postgresql.org; Tue, 14 May 2024 07:58:03 +0000 Received: by mail-pg1-x52a.google.com with SMTP id 41be03b00d2f7-5dcc4076c13so3535985a12.0 for ; Tue, 14 May 2024 00:58:01 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1715673479; x=1716278279; darn=postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=Vq5UqzaQqWzhifyJIImP5hAqOFNQUEhdK8KYNK4h9mA=; b=FOHZZSYoaYNWDsoasAnleDkfrd2HMWPclzBgIcNZGfwmFirN04NN47+w6ZclAZLuhg A4dLNril1AKFNnvZmXDhyKCWBHimWBYaIO0333VBzMdcZAQQtH+sUb6qVoXHPDjQrwNt 96G/YBYTRQ+pzkxlLkKxQyFG5KXxPhyxrFUYfTBEJtczU0UBqVQx2iAfqEmD5p6xhqrt dXuKSjBEwP8zRNE9duimiUa3tDhkRMngmoP4zXfnSeRYAvu3tK0jSQsVR6c1XdUllri2 CU97SAS1C8AIZP/jaOx/SqWb+rjgjN/WK8SR/qD9t3aSTEttxgLpn+jkn3drE24rSfjN kLdg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1715673479; x=1716278279; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=Vq5UqzaQqWzhifyJIImP5hAqOFNQUEhdK8KYNK4h9mA=; b=UvlSrRacsafmVGa4B9i840YrizPnNBzrHfBXSeH8t7lwQ7r6lbKhDQGSqXq+tswByt h+HHMdR9dDzoDbXxdfA+qP8VfymSLaDOvXuBPvtuKel4WyvIJJ+/Ql1LdkXwqHPsvKyO 7NjV7T4YoKNPJ5CbwlO5tuicBYUYXavRHhAFI1Pobj5TYgA0x5Y/q0CavJ0AFb8y9Hg3 l45A7dTKWHe/Csspzq8MhlJUKZYacVnzRE7YOm0OrJGHpXOHStntj/23MTSlMsTQJUPg PhX73PHDnVik6PpmC0RPNlQF07Oocbklp+dI7xgbnAyD9jtxbx28kAsWN7j37h5dUkCN CQcw== X-Gm-Message-State: AOJu0Yxn8ZLTZzWlQfT6eQQyQSZapk5E0UDvpG0JO/8+fJ+lTtIf/vHr Pjq7yjOmme9wudJaoQQUwP41yanHS2j0TeuaN7z2tthcqy9ErYnKjt5rwKpg8Ce1JrAdduLq4rA ytzJNJMZTWP2uzaqckzH9MQLqHe8HSw== X-Google-Smtp-Source: AGHT+IFNp7T5FxeuXuKhCNjhjrc9WY2UIzmJTabE3PQn7Lm46RNUh+A6OiQxP4y/R10Wa6r1Jr5yOI+X7IfnEWC4WCs= X-Received: by 2002:a17:90a:7e10:b0:2b3:390c:e3f0 with SMTP id 98e67ed59e1d1-2b6c75dbe8fmr16661414a91.16.1715673479266; Tue, 14 May 2024 00:57:59 -0700 (PDT) MIME-Version: 1.0 From: Rama Krishnan Date: Tue, 14 May 2024 13:27:47 +0530 Message-ID: Subject: Valid until To: Postgres General Content-Type: multipart/alternative; boundary="000000000000484c050618655ce6" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000484c050618655ce6 Content-Type: text/plain; charset="UTF-8" Hi team, I have a question about the "valid until" parameter in the "create role" command. I recently set a user's password validity to "2024-05-13", but despite this, the user is still able to connect to the database. Is this a bug, or is the "valid until" parameter just for identification purposes, indicating when the password will expire? Could you please clarify this for me? Thanks Ram --000000000000484c050618655ce6 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi team,

I have a question about the "valid until" pa= rameter in the "create role" command.

=
I recently set a user's password validity to &q= uot;2024-05-13", but despite this, the user is still able to connect t= o the database. Is this a bug, or is the "valid until" parameter = just for identification purposes, indicating when the password will expire?=

Could you please clarif= y this for me?


Thanks

Ram
--000000000000484c050618655ce6--