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 1sk1zU-006v3f-6v for pgsql-general@arkaria.postgresql.org; Fri, 30 Aug 2024 13:48:40 +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 1sk1zS-004ixm-8Q for pgsql-general@arkaria.postgresql.org; Fri, 30 Aug 2024 13:48:38 +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 1sk1zR-004ivY-TY for pgsql-general@lists.postgresql.org; Fri, 30 Aug 2024 13:48:38 +0000 Received: from mail-oo1-xc32.google.com ([2607:f8b0:4864:20::c32]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sk1zL-002Fw6-9j for pgsql-general@lists.postgresql.org; Fri, 30 Aug 2024 13:48:37 +0000 Received: by mail-oo1-xc32.google.com with SMTP id 006d021491bc7-5dfaff47600so300563eaf.0 for ; Fri, 30 Aug 2024 06:48:32 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1725025711; x=1725630511; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=GhKzhs6ZZP0LYDnFnoPzX0I5TzXDrdPvwhMTgMdNkow=; b=Q6NliqjQ1e/rzaFxuNy+NEUGdLr1Vn5RK7TVz9QiJQ+h7JNWlvM1hutFnToXoE8a06 bArGXAbXfGHlKK7azM+anegbYMwTykHxVm8mGAUfO8wzB2KzmiT82aWi3cvIsr39emel jmPd0rG7CUnIlJtzcImoOgKFeT8Bb155HjsCzWItD6YFDGnCOkTxk/YLKAHo5UXL/pfH Qk0DgaRsB4d6txsvCjH+xeNDTXAHVqz3jbZ+SCMZNUMeKBmlcNZMAYgOeAU+aNhXvhKt Y1ReCW4VLX8LT9vd6l9gR+4u5DE4lXp9D6SadYRLqX1VKQvNZntnZlK0Ee5o/x5IS+3Y BKAA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1725025711; x=1725630511; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=GhKzhs6ZZP0LYDnFnoPzX0I5TzXDrdPvwhMTgMdNkow=; b=KAc86kMoor2LyEa1ZA3JoRKh2BOndDoSuUfa+ApuQZ+SbMSB2O8ke3OqO451Aee13A X/PXARVaNC/fmcndBmY4ZUcE3mVVLIuWsCR5rO/9vrcHkqF4ffIispICVwFnKBz4zXrY d09RNC9AfwABzRx66VWC1zUi3ZGDB0b87FcPAZHzeREWo7gq48z11HgC8Zw7DQsADCT7 QHf5iWR6hwRoexJHUfuh2S3FC8DBG4CsiYQTZ7mP1Sep7UMV3kFFANmaLC35i3XJ6zeS ZuT0AxW6OcVrBsJEI2LS/SqwLu2z6y/vMh8Bnzx38Ok56RPKGk7jkEnFy3Nr2K56NbvD ut5Q== X-Gm-Message-State: AOJu0YypyYd7MkLod314qU/q/LcHPw4Q03yH4OSDr43AqlbQPzVs/Gxr Bm9zR7ONduzIdzCo+S4Z7SIvdS1PnsrYwF6hxwWmOI7EMqOH7fAqiRtYU37RqAfbjIOQg7Vjmlp 7sfnMgdnvDPOjFuY34Cel1YYIto4= X-Google-Smtp-Source: AGHT+IGx4QrrUM59aHCPb5VtzVSLbOCNEsJFHe3yqox3tpYrmmDoMMMwNwQhrHEWl+QlTd2SqcCjZ9tCdkaxjhgz+D4= X-Received: by 2002:a05:6820:6485:b0:5d8:a13:f99d with SMTP id 006d021491bc7-5df9aac7779mr2368067eaf.1.1725025710655; Fri, 30 Aug 2024 06:48:30 -0700 (PDT) MIME-Version: 1.0 Received: by 2002:ac9:6694:0:b0:557:c384:fb61 with HTTP; Fri, 30 Aug 2024 06:48:30 -0700 (PDT) In-Reply-To: References: From: "David G. Johnston" Date: Fri, 30 Aug 2024 06:48:30 -0700 Message-ID: Subject: Re: default privileges are npt working To: Atul Kumar Cc: pgsql-general Content-Type: multipart/alternative; boundary="000000000000b6515f0620e6d8ec" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000b6515f0620e6d8ec Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Friday, August 30, 2024, Atul Kumar wrote: > > > I have a postgres instance running on version 15 in centos7. > > I have created a custom database and revoked all public privileges from > that database. > Would be better to provide the actual psql script of what you=E2=80=99ve do= ne instead of writing it out in prose. That way the question of whether you=E2= =80=99ve done something wrong or not is directly and accurately answerable David J. --000000000000b6515f0620e6d8ec Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Friday, August 30, 2024, Atul Kumar <akumar14871@gmail.com> wrote:

I have a postgres instance running on= version 15 in centos7.

I have created a custom da= tabase and revoked all public privileges from that database.

Would be better to provide the actual psql sc= ript of what you=E2=80=99ve done instead of writing it out in prose. That w= ay the question of whether you=E2=80=99ve done something wrong or not is di= rectly and accurately answerable

David J.
--000000000000b6515f0620e6d8ec--