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 1kxsUU-0006sQ-Vv for pgsql-admin@arkaria.postgresql.org; Fri, 08 Jan 2021 14:11: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 1kxsUS-0002hf-U2 for pgsql-admin@arkaria.postgresql.org; Fri, 08 Jan 2021 14:11:44 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kxsUS-0002hY-Kk for pgsql-admin@lists.postgresql.org; Fri, 08 Jan 2021 14:11:44 +0000 Received: from mail-wr1-x42f.google.com ([2a00:1450:4864:20::42f]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1kxsUQ-0004R2-14 for pgsql-admin@postgresql.org; Fri, 08 Jan 2021 14:11:44 +0000 Received: by mail-wr1-x42f.google.com with SMTP id t16so9165320wra.3 for ; Fri, 08 Jan 2021 06:11:41 -0800 (PST) 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=1bHy/ez66DxQxv4q5P5fZeu95PA/5tudmKXRKnCscWY=; b=Kthbx4n2Yl0YqUq2LAqMXzUUAIWdtnaQAfvjSLW66IWT/RF04/J4QqMBSEi9yqdO5n FDJVrJ1PwZDODp0m2jz9ERGvoi+hzrncawXAPKdgjErQ9stpby5oxgp57NZEZEHop+AW WVww7zaBifZWcgwjrGY5hIcBf4XtKSBoa/1PtbnPB+baQt1gJFBBUmmDCHi+lAR/STDZ fqBuzaDc/N0dWl0hrGprPteduu3Ib0vm7zcNbyDukLL+y6ZxFC/ft5XRwSKA/z9UP3zd YKFJXu04NlcsZvuvdQHJhR+tVjttI+PVnsA0BvWpb6Ioo2YO9IqcPKkWUTJxhzIYXCYU ENgg== 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=1bHy/ez66DxQxv4q5P5fZeu95PA/5tudmKXRKnCscWY=; b=MNCdiT07UZnyLHVwrl2JtrNjz+BDIrhMcTlzHhkbZSsoza8clUuIlutRaP/FFT5QfC 0GsXnqTJvQevkU+iCaKBBYfN7aGyblaOjiYm9ArL2IJGtEeACTCjTvxpYwlYVu4JVZNt WeOyEjv0jxPQ7kd2Oj6VvkYB8ZrL6jLmPPA81oXl7UIenm7fJY3HLMimLyj9JCjp2cW9 FV2p0Aetxx2OtMNUl9UO5S+XOUDVLVYyoficLYf59na7N+Rnzo1Mws9DeppAU78P1B6Z /fwjy9a3XSG03duO5cYYgYgpgsxs65S7XzmJGY7YDhhAu5klsdhMPc/aOADyw3fbs9MF eAwA== X-Gm-Message-State: AOAM532i+O3hWLsjcssuL7XkSwDgjI4PygUkJJWn+kXO8HnLJloNtUTO 5oR5CTINL0spE7MMoXKdDLc= X-Google-Smtp-Source: ABdhPJwhfgq2/PaQDdKGSPOQjDJoNEtTJhbfs9Qk+wmZxdIgzQ7SVr6eCd5y2ZatIPJ8jrQqq298UA== X-Received: by 2002:a5d:674b:: with SMTP id l11mr3974004wrw.247.1610115101262; Fri, 08 Jan 2021 06:11:41 -0800 (PST) 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 r82sm12674828wma.18.2021.01.08.06.11.40 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Fri, 08 Jan 2021 06:11:40 -0800 (PST) Content-Type: text/plain; charset=us-ascii Mime-Version: 1.0 (Mac OS X Mail 14.0 \(3654.40.0.2.32\)) Subject: Re: Permission to create a table in postgresql database From: =?utf-8?Q?Paul_F=C3=B6rster?= In-Reply-To: Date: Fri, 8 Jan 2021 15:11:40 +0100 Cc: pgsql-admin Content-Transfer-Encoding: quoted-printable Message-Id: References: To: dbatoCloud Solution X-Mailer: Apple Mail (2.3654.40.0.2.32) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Hi Ashok, > On 08. Jan, 2021, at 14:58, dbatoCloud Solution = wrote: >=20 > I want to grant permission to user to create a table, alter table , = create=20 > sequence in postgresql database . >=20 > Please advice me see: https://www.postgresql.org/docs/current/sql-grant.html I guess, the first syntax should be what you want. Cheers, Paul=