Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1ec9vb-0007vt-Vf for pgsql-admin@arkaria.postgresql.org; Thu, 18 Jan 2018 13:08:24 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1ec9vb-0007ld-Il for pgsql-admin@arkaria.postgresql.org; Thu, 18 Jan 2018 13:08:23 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1ec9vb-0007lU-C2 for pgsql-admin@lists.postgresql.org; Thu, 18 Jan 2018 13:08:23 +0000 Received: from mx2.mailbox.org ([80.241.60.215]) by magus.postgresql.org with esmtps (TLS1.2:RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ec9vX-00049p-IC for pgsql-admin@lists.postgresql.org; Thu, 18 Jan 2018 13:08:22 +0000 Received: from smtp2.mailbox.org (smtp2.mailbox.org [80.241.60.241]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by mx2.mailbox.org (Postfix) with ESMTPS id E74904049E; Thu, 18 Jan 2018 14:08:17 +0100 (CET) X-Virus-Scanned: amavisd-new at heinlein-support.de Received: from smtp2.mailbox.org ([80.241.60.241]) by hefe.heinlein-support.de (hefe.heinlein-support.de [91.198.250.172]) (amavisd-new, port 10030) with ESMTP id O73LEr7ub5jL; Thu, 18 Jan 2018 14:08:13 +0100 (CET) Message-ID: <1516280891.924.45.camel@cybertec.at> Subject: Re: Issue with grant & revoke From: Laurenz Albe To: Venkataramana Aitla , pgsql-admin@lists.postgresql.org Date: Thu, 18 Jan 2018 14:08:11 +0100 In-Reply-To: References: Organization: Cybertec Content-Type: text/plain; charset="UTF-8" Mime-Version: 1.0 Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Venkataramana Aitla wrote: > How can we revoke alter and drop privileges from user/schema...?? Use the GRANT and REVOKE statements: https://www.postgresql.org/docs/current/static/sql-grant.html https://www.postgresql.org/docs/current/static/sql-revoke.html Read the chapter on privileges: https://www.postgresql.org/docs/current/static/ddl-priv.html Privileges are additive, so if you try to revoke a privilege that was not granted, it will do nothing. In psql, use \z to list a table's privileges and \dn+ to list privileges on a schema. Yours, Laurenz Albe