X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 8963952BF3 for ; Wed, 17 Aug 2005 12:57:22 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 31147-10 for ; Wed, 17 Aug 2005 15:57:16 +0000 (GMT) Received: from smtp3.gtdinternet.com (smtp3.gtdinternet.com [200.75.0.33]) by svr1.postgresql.org (Postfix) with ESMTP id 0EC34529C3 for ; Wed, 17 Aug 2005 12:57:15 -0300 (ADT) Received: from telsur.com (correo4.gtdinternet.com [200.75.0.12]) by smtp3.gtdinternet.com (Postfix) with ESMTP id D0CD2286CB7; Wed, 17 Aug 2005 11:58:06 -0400 (CLT) Received: from correo4.gtdinternet.com(200.75.0.12) by av1.gtdinternet.com via smtp id 78fc_9c18ec8c_0f37_11da_95ec_0002b3ebca3b; Wed, 17 Aug 2005 11:57:28 -0400 Received: from alvh.no-ip.org [200.85.218.206] by telsur.com with ESMTP (SMTPD32-8.15) id AE5751100BC; Wed, 17 Aug 2005 11:57:11 -0400 Received: from 200-85-218-206.bk4-dsl.surnet.cl(200.85.218.206) by av1.gtdinternet.com via smtp id 787f_9aa300e0_0f37_11da_9e9b_0002b3ebca3b; Wed, 17 Aug 2005 11:57:26 -0400 Received: by alvh.no-ip.org (Postfix, from userid 1000) id 3551EC2DC09; Wed, 17 Aug 2005 11:57:53 -0400 (CLT) Date: Wed, 17 Aug 2005 11:57:53 -0400 From: Alvaro Herrera To: Andrew Gold Cc: pgsql-admin@postgresql.org Subject: Re: GRANT ALL PRIVILEGES ON DATABASE Message-ID: <20050817155753.GA23134@alvh.no-ip.org> Mail-Followup-To: Andrew Gold , pgsql-admin@postgresql.org References: <430271C8.8030909@cbamedia.com> <1124236833.12095.101.camel@linda> <4303592A.4070501@cbamedia.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <4303592A.4070501@cbamedia.com> User-Agent: Mutt/1.5.9i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.717 required=5 tests=[AWL=0.293, DNS_FROM_RFC_ABUSE=0.374, FORGED_RCVD_HELO=0.05] X-Spam-Level: X-Archive-Number: 200508/220 X-Sequence-Number: 18539 On Wed, Aug 17, 2005 at 08:35:06AM -0700, Andrew Gold wrote: > This followed a series of descriptions of various privileges (select, > insert, update, etc.). From the context of the description, it appears > that "GRANT ALL PRIVILEGES" bestows all of the preceding rights on the > recipient user. > > It is not at all intuitive that "GRANT ALL PRIVILEGES" gives a user the > right to create schemas and temporary tables, and that alone. If you have a suggestion for a better wording, please share -- there's always room for improving the documentation. -- Alvaro Herrera () "Tiene valor aquel que admite que es un cobarde" (Fernandel)