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 94CCB564B9 for ; Thu, 10 Mar 2005 17:01:35 +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 87715-03 for ; Thu, 10 Mar 2005 17:01:25 +0000 (GMT) Received: from web21323.mail.yahoo.com (web21323.mail.yahoo.com [216.136.175.209]) by svr1.postgresql.org (Postfix) with SMTP id 49A4556532 for ; Thu, 10 Mar 2005 17:01:22 +0000 (GMT) Received: (qmail 25583 invoked by uid 60001); 10 Mar 2005 17:01:21 -0000 Comment: DomainKeys? See http://antispam.yahoo.com/domainkeys DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; b=G+Hz73Pxy4kk2XKT/wigYK+Dx2s/gWmn7bg2k6zf5s7ClMOnNszXun4n46NlwxNKyYmngdUcBOVeCXkU15iCFkpvjOPUDQH/xuKuAnFvqjw0aOVuZaKkiTiC0RAGKAkLFo4P3fph97V+DFynSVsNXuqZVks9nz189PWrQTghZms= ; Message-ID: <20050310170121.25581.qmail@web21323.mail.yahoo.com> Received: from [64.59.17.210] by web21323.mail.yahoo.com via HTTP; Thu, 10 Mar 2005 09:01:21 PST Date: Thu, 10 Mar 2005 09:01:21 -0800 (PST) From: Hemapriya Subject: Grant ALL on schema To: pgsql-admin@postgresql.org, pgsql-hackers@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.796 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, FROM_ENDS_IN_NUMS X-Spam-Level: X-Archive-Number: 200503/154 X-Sequence-Number: 16652 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. Thanks Priya __________________________________ Do you Yahoo!? Yahoo! Mail - You care about security. So do we. http://promotions.yahoo.com/new_mail