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 2CDF3565FC for ; Fri, 11 Mar 2005 14:40:00 +0000 (GMT) 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 49288-08 for ; Fri, 11 Mar 2005 14:39:59 +0000 (GMT) Received: from wolff.to (wolff.to [66.93.249.74]) by svr1.postgresql.org (Postfix) with SMTP id 74840565AD for ; Fri, 11 Mar 2005 14:39:58 +0000 (GMT) Received: (qmail 32762 invoked by uid 500); 11 Mar 2005 14:55:54 -0000 Date: Fri, 11 Mar 2005 08:55:54 -0600 From: Bruno Wolff III To: Hemapriya Cc: pgsql-admin@postgresql.org, pgsql-hackers@postgresql.org Subject: Re: Grant ALL on schema Message-ID: <20050311145554.GB29934@wolff.to> Mail-Followup-To: Bruno Wolff III , Hemapriya , pgsql-admin@postgresql.org, pgsql-hackers@postgresql.org References: <20050310170121.25581.qmail@web21323.mail.yahoo.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20050310170121.25581.qmail@web21323.mail.yahoo.com> User-Agent: Mutt/1.5.6i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.008 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200503/177 X-Sequence-Number: 16675 On Thu, Mar 10, 2005 at 09:01:21 -0800, Hemapriya wrote: > Hi, > > Can anybody know how the following statement work. > > Grant ALL on SCHEMA test to user 'user1'; > > will the user be able to have all the privileges on > all the objects/tables on schema test? Or he can only > create new objects in that schema. That will grant CREATE and USAGE access to the schema, so that the user will be able to look up objects in the schema and create new objects in the schema. It won't change the access rights associated with objects in the schema.