Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1gJe49-00024a-JI for pgsql-admin@arkaria.postgresql.org; Mon, 05 Nov 2018 12:33:13 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gJe47-00055Q-4R for pgsql-admin@arkaria.postgresql.org; Mon, 05 Nov 2018 12:33:11 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1gJe3n-0003dX-AE for pgsql-admin@lists.postgresql.org; Mon, 05 Nov 2018 12:32:51 +0000 Received: from hermes.gatewaynet.com ([193.92.121.98]) by makus.postgresql.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gJe3h-0000fO-HM for pgsql-admin@lists.postgresql.org; Mon, 05 Nov 2018 12:32:49 +0000 Received: from smadev.internal.net (pc131.internal.net [10.9.200.131]) by hermes.gatewaynet.com (8.14.3/8.14.3/Debian-9.4) with ESMTP id wA5CWZVE003542 for ; Mon, 5 Nov 2018 14:32:40 +0200 Received: from smadev.internal.net (smadev [10.9.200.131]) by smadev.internal.net (8.15.2/8.15.2) with ESMTP id wA5CWZmF042299 for ; Mon, 5 Nov 2018 14:32:35 +0200 (EET) (envelope-from achill@matrix.gatewaynet.com) Subject: Re: How to revoke "Create Privilege" from a readonly user in postgres? To: pgsql-admin@lists.postgresql.org References: <1541419964128-0.post@n3.nabble.com> From: Achilleas Mantzios Message-ID: <06ca3880-b33d-35d7-f040-61dbfb8c20ab@matrix.gatewaynet.com> Date: Mon, 5 Nov 2018 14:32:35 +0200 User-Agent: Mozilla/5.0 (X11; FreeBSD amd64; rv:60.0) Gecko/20100101 Thunderbird/60.0.1 MIME-Version: 1.0 In-Reply-To: <1541419964128-0.post@n3.nabble.com> Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit Content-Language: en-US X-Virus-Scanned: clamav-milter 0.98.7 at hermes X-Virus-Status: Clean X-Spam-Status: No, score=-22.8 required=5.0 tests=ALL_TRUSTED,DYN_HAM_COORD, DYN_HAM_IT,DYN_HAM_NAUTICAL,DYN_HAM_SIGNAT1,DYN_SPAM_MED6,DYN_SPAM_MED7, DYN_SPAM_SUBJ autolearn=unavailable version=3.3.1 X-Spam-Checker-Version: SpamAssassin 3.3.1 (2010-03-16) on hermes.gatewaynet.com List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 5/11/18 2:12 μ.μ., pavan95 wrote: > Hi, > > I want to know if there is anyway to disallow a user from creating his own > tables. > He should be only provided with the "SELECT" access apart from that no other > access should be available with him. > > I have created a user "readonly" with no other privilege other select on > database "abc". But when I tried to connect as "readonly" he is given with > "SELECT" privilege but the problem here is he was also be able to create his > own tables in the database. Check out privileges you have given to PUBLIC. Those hold still for all future users. > > How this can be stopped? Looking forward to hear from you. > > Regards, > Pavan > > > > -- > Sent from: http://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html > -- Achilleas Mantzios IT DEV Lead IT DEPT Dynacom Tankers Mgmt