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 1kxswn-0007ef-JY for pgsql-admin@arkaria.postgresql.org; Fri, 08 Jan 2021 14:41:01 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kxswm-0004m0-IA for pgsql-admin@arkaria.postgresql.org; Fri, 08 Jan 2021 14:41:00 +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 1kxswm-0004lt-60 for pgsql-admin@lists.postgresql.org; Fri, 08 Jan 2021 14:41:00 +0000 Received: from mail-ed1-x529.google.com ([2a00:1450:4864:20::529]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1kxswh-0004ly-MX for pgsql-admin@postgresql.org; Fri, 08 Jan 2021 14:40:59 +0000 Received: by mail-ed1-x529.google.com with SMTP id i24so11387594edj.8 for ; Fri, 08 Jan 2021 06:40:55 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20150623.gappssmtp.com; s=20150623; h=message-id:subject:from:to:date:in-reply-to:references:user-agent :mime-version:content-transfer-encoding; bh=CxOu9TGy5n3S/UrfP1EzOfg0ezcRh9rWwqNAXj3wCvw=; b=k5Aier6km70P/ao2E9hR+lWIjnlq7ZWN7xfpimFnp2yfzlyBLMzbgZ7Ce1TxHExgUz 6d/mFDwteq57ezaQ8PGpmb2f+TDqYy+JFcVdOe1zetqChBriQp63oibM9hPzaNVtXyvV zJJyV0rRspqEwTyu1nXH1cR2LMzR9Ax8Cw2wA7mg5h4lZXlS1HgGgM5N0eb8Fp4OZ2ox s4nlGpOiCtNd2jMWywmgO4/X5sfbe4BAmEZBoBVO6gqZMQVSMbWozJvJjrSGbq0tcbNQ JE3CTtSc/K7aG6vUQZwXugu9FsdFAICOWR6mpCkOrxvJfN1YWePheJhUu0dmQ+4GCULe 16Qg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:message-id:subject:from:to:date:in-reply-to :references:user-agent:mime-version:content-transfer-encoding; bh=CxOu9TGy5n3S/UrfP1EzOfg0ezcRh9rWwqNAXj3wCvw=; b=S5zXGU1xhMHAmkEAKhje14jhVz0d3jIzt+3YYz7Q9OXJxeyjt5l79a4zkqGg5BPEPn RVHkcCrUZXLzFeIpCMiUlRVzEo2jva9QWJGYVsy7RvardAK67uPMONQ2UabYfJoQzkvJ QCltX0rZzXlCYrEvSkAH/u8hKQbbg4mylAh/SCbpqNxz8Vtgoij5S01p7Wm+wYNx5LVc pgr45QqUXKKfKV38Lmop9CYltOaK/xs1E+JZfKXd3bfNzoDbh4E8HGEvwSyYsnyt3Ht6 ujhYm2zP24XHFVhthEPaOpqKPqqo3U2n3y/6zLZU5CMgzlaj/K9G4MN8QjXMWZSDX6R1 BitA== X-Gm-Message-State: AOAM530cyx2dI8u9SeBKaNV5nMDUTHvnynic1VJeiICl8Rp4HEZie0dy tpNHDjJmPb75Y1wGqHmLTcbdxA== X-Google-Smtp-Source: ABdhPJybywlA62T+ppOSzcz/7jIezLVDbyYPveNTmI0KTdpjX49gscylAil6uJnw95l0i4AQOOhr5Q== X-Received: by 2002:a05:6402:308b:: with SMTP id de11mr5349117edb.205.1610116854725; Fri, 08 Jan 2021 06:40:54 -0800 (PST) Received: from localhost.localdomain (217-149-174-246.nat.highway.telekom.at. [217.149.174.246]) by smtp.gmail.com with ESMTPSA id oq27sm3539332ejb.108.2021.01.08.06.40.54 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 08 Jan 2021 06:40:54 -0800 (PST) Message-ID: Subject: Re: Permission to create a table in postgresql database From: Laurenz Albe To: dbatoCloud Solution , pgsql-admin@postgresql.org Date: Fri, 08 Jan 2021 15:40:53 +0100 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" User-Agent: Evolution 3.36.5 (3.36.5-2.fc32) MIME-Version: 1.0 Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Fri, 2021-01-08 at 19:28 +0530, dbatoCloud Solution wrote: > I want to grant permission to user to create a table, alter table , create > sequence in postgresql database . Every user is always allowed to create tables and sequences, and every user can alter objects that it owns. To allow a user to create an object in a certain schema, give the user the CREATE privilege on the schema. Yours, Laurenz Albe -- +43-670-6056265 CYBERTEC PostgreSQL International GmbH Gröhrmühlgasse 26, A-2700 Wiener Neustadt Web: https://www.cybertec-postgresql.com