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 1kGygR-0005aC-RQ for pgsql-admin@arkaria.postgresql.org; Sat, 12 Sep 2020 06:06:47 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kGygP-0005IW-Gp for pgsql-admin@arkaria.postgresql.org; Sat, 12 Sep 2020 06:06:45 +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 1kGygP-0005IO-7W for pgsql-admin@lists.postgresql.org; Sat, 12 Sep 2020 06:06:45 +0000 Received: from mail-ej1-x62c.google.com ([2a00:1450:4864:20::62c]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1kGygM-0003TC-VO for pgsql-admin@lists.postgresql.org; Sat, 12 Sep 2020 06:06:44 +0000 Received: by mail-ej1-x62c.google.com with SMTP id u21so16357161eja.2 for ; Fri, 11 Sep 2020 23:06:42 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:subject:from:in-reply-to:date:cc :content-transfer-encoding:message-id:references:to; bh=MxpzdBFJ78mBhNUgzlsLbip4QM9rDIUeM1NQ3ybNlNQ=; b=feEb8jwxBbDH3v8jgsmEdQnwm2ZxvXGvBIC7w7SJ5z1WxWbEVcCJEh3kGLUmbQiApw bQIZj32tiofSEJIoXlDIpOksviYTtDuoGSI+GIZ+tU1nH74COhDpsfIs/+aa/4b8OmKH eL/3DxIfS2Lxgg00TYuCQpJ3NlF70zuWFf2IqX2AEp5ZFHUhoK046fT/x20UmH5XJt96 9VBI1XmnnlXaTYxCSD4hSBQ6lGEllnb1K72zrBuJ+HZlJ1JNBai8SuoeOILtci/mxhZe FmBi/6qGA1dhGs80MnCEuR4Xx7H7PZufKiUBvjzDb0h+QsXFk95nchiB0x4Y5Y8t62Sh rlnw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:subject:from:in-reply-to:date:cc :content-transfer-encoding:message-id:references:to; bh=MxpzdBFJ78mBhNUgzlsLbip4QM9rDIUeM1NQ3ybNlNQ=; b=maAuBCGeM3AUfWdnjaEBQIsxDFbuEI8wINdigyVuN8fXmJa8KOnTAn3ZJs5NjqBG9V KOEC+WxuGn8R+L0Cd4r1XO46H/nmtg23H8jScF4aLjjxV2fnazYfQ6eOuYnG3zOI/1Hs TarUPDl3dFT/2db+6jpVMUFz5wRKL2a/KHpqyRM2HJpmDqks5PpKQGjHpx8vaG/IAnpA QY8NxJ8D4yjlGFTyzXgvHSWGUs0KETlOKKCCj5sMymC6lWW++IvYcn8lNsMdmqW5RAeH MTdHqxNU65HHWA3F6R+q0FcZvArTHBvVq/c+mTjIp+4F5EFdWeI+fp/E2lTJQpTrlWFK TmVA== X-Gm-Message-State: AOAM5339KFjfVckMdAHWQ/gVwPnXesL+SDkTCLEhrjZvvECIVTj088wy ncu8DVy5ogEs2I1sX+KCAyw= X-Google-Smtp-Source: ABdhPJxBBl219N38WkwWqkLVkbyJDxnxuJZ34daYQ5LBT9mwkwK9hZPAtxW4RMHrr7yhtPnOZyVaBw== X-Received: by 2002:a17:906:9491:: with SMTP id t17mr5192425ejx.253.1599890800374; Fri, 11 Sep 2020 23:06:40 -0700 (PDT) Received: from [192.168.1.8] (241-57-239-77.dyn.cable.fcom.ch. [77.239.57.241]) by smtp.gmail.com with ESMTPSA id be2sm3683832edb.0.2020.09.11.23.06.39 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Fri, 11 Sep 2020 23:06:40 -0700 (PDT) Content-Type: text/plain; charset=us-ascii Mime-Version: 1.0 (Mac OS X Mail 13.4 \(3608.120.23.2.1\)) Subject: Re: schema postgresql From: =?utf-8?Q?Paul_F=C3=B6rster?= In-Reply-To: Date: Sat, 12 Sep 2020 08:06:35 +0200 Cc: pgsql-admin@lists.postgresql.org Content-Transfer-Encoding: quoted-printable Message-Id: <86C9BF27-A856-40B2-BC2A-EF05AE0FA330@gmail.com> References: To: Henry Francisco Garcia Cortez X-Mailer: Apple Mail (2.3608.120.23.2.1) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Hi Henry, > On 11. Sep, 2020, at 23:13, Henry Francisco Garcia Cortez = wrote: >=20 > how to restrict a user from seeing a schema in postgresql for example: revoke all privileges on from ; See: https://www.postgresql.org/docs/current/sql-revoke.html Cheers, Paul=