X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id D3C7BD1C94B for ; Thu, 15 Apr 2004 03:57:36 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 77172-10 for ; Thu, 15 Apr 2004 03:57:35 -0300 (ADT) Received: from chn-dns.primus-india.net (chn-dns.primus-india.net [203.196.153.7]) by svr1.postgresql.org (Postfix) with ESMTP id 3A100D1B8B7 for ; Thu, 15 Apr 2004 03:57:32 -0300 (ADT) Received: from ivesia67 (ptil-138-190-chn.primus-india.net [203.196.190.138] (may be forged)) by chn-dns.primus-india.net (8.12.8/8.12.8) with SMTP id i3F5uKWe011795 for ; Thu, 15 Apr 2004 11:26:21 +0530 Message-ID: <017d01c422b7$0220cc80$7502a8c0@hdsc.com> From: "kumar" To: "pgsql" Subject: Grant permission to all objects of user A to user B Date: Thu, 15 Apr 2004 12:28:06 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_017A_01C422E5.1AB87D50" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.1 tagged_above=0.0 required=5.0 tests=BAYES_44, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200404/132 X-Sequence-Number: 17507 This is a multi-part message in MIME format. ------=_NextPart_000_017A_01C422E5.1AB87D50 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Dear Friends, Postgres 7.3.2. I have an database with owner USRA who owns about 300 objects (tables and f= unctions). Now I want to give 'ALL' permission to all the objects of USRA t= o another database user USRB. If I use the grant i need to type all the objects as comma separated, like = the following booktown=3D# GRANT ALL ON customers, books, editions, publishers booktown-# TO manager; CHANGEIs there any other way do it.ThanksKumar ------=_NextPart_000_017A_01C422E5.1AB87D50 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Dear Friends,
 
Postgres 7.3.2.
 
I have an database with owner USRA who own= s about=20 300 objects (tables and functions). Now I want to give 'ALL' permission to = all=20 the objects of USRA to another database user USRB.
 
If I use the grant i need to type all the = objects=20 as comma separated, like the following
booktown=3D# GRANT ALL ON=
 customers, books, editions, publishers
booktown-#           TO manager;
CHANGE
Is there any other way do it.
 
Thanks
Kumar
------=_NextPart_000_017A_01C422E5.1AB87D50--