X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (mx1.hub.org [200.46.208.251])
	by postgresql.org (Postfix) with ESMTP id 468219FB1DD
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed,  3 May 2006 01:08:09 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024)
	with ESMTP id 83966-08
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed,  3 May 2006 01:07:59 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-
Received: from web30413.mail.mud.yahoo.com (web30413.mail.mud.yahoo.com
	[68.142.201.236])
	by postgresql.org (Postfix) with SMTP id 2C86E9FB1D5
	for <pgsql-sql@postgresql.org>; Wed,  3 May 2006 01:07:58 -0300 (ADT)
Received: (qmail 5000 invoked by uid 60001); 3 May 2006 04:07:57 -0000
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding;
	b=tb+fYEZ+vwJ92WfTO8I7oBVL/dGPuC3kbHenVWdutAZx11JAoGHcLfkNBW3SQ6LmQcDGuB6OYY/VvujxEzpJCsdqkqllNzRFpsslngKcqa9lmbPiKNigCFOk3HjQ9cP5mkFG1SlS5dO3NOA4pekSFXljgRYp/tZJgmr3RMQzJwQ=
	;
Message-ID: <20060503040757.4998.qmail@web30413.mail.mud.yahoo.com>
Received: from [203.115.30.220] by web30413.mail.mud.yahoo.com via HTTP;
	Tue, 02 May 2006 21:07:57 PDT
Date: Tue, 2 May 2006 21:07:57 -0700 (PDT)
From: Thusitha Kodikara <kthusi@yahoo.com>
Subject: Re: grant select on database demo to user
To: bryce1@obviously.com, pgsql-sql@postgresql.org
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-213577103-1146629277=:4621"
Content-Transfer-Encoding: 8bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200605/22
X-Sequence-Number: 25053

--0-213577103-1146629277=:4621
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

Hi,

You could easily generate a script with the list of tables and the required grant information and then run it to give the necessary grants. (The list of tables may be obtained by querying tables in 'information_schema')

Regards,
-Thusitha

  -----Original Message-----
 From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org] On Behalf Of Bryce Nesbitt
 Sent: Wednesday, May 03, 2006 9:03 AM
 To: pgsql-sql@postgresql.org
 Subject: [SQL] grant select on database demo to user
   
  I find myself with long lists of tables
   
    grant select on xx_tax to user;
    grant select on xx_trip to user;
    grant select on xx_foo to user;
   
  Is there a way to grant to all tables, with a single grant?  I know how
  to do it in mysql, but not postgres.  As close as I get it:
   
  #grant select on database demo to user
  ERROR:  invalid privilege type SELECT for database
   
  -- 
  ----
  Visit http://www.obviously.com/
   
   
   
  ---------------------------(end of broadcast)---------------------------
  TIP 9: In versions below 8.0, the planner will ignore your desire to
         choose an index scan if your joining column's datatypes do not
         match
   
   
  -- 
  
--0-213577103-1146629277=:4621
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

Hi,<br><br>You could easily generate a script with the list of tables and the required grant information and then run it to give the necessary grants. (The list of tables may be obtained by querying tables in 'information_schema')<br><br>Regards,<br>-Thusitha<br><br>  <div class="MsoPlainText">-----Original Message-----<br> From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org] On Behalf Of Bryce Nesbitt<br> Sent: Wednesday, May 03, 2006 9:03 AM<br> To: pgsql-sql@postgresql.org<br> Subject: [SQL] grant select on database demo to user</div>  <div class="MsoPlainText"><o:p>&nbsp;</o:p></div>  <div class="MsoPlainText">I find myself with long lists of tables<o:p></o:p></div>  <div class="MsoPlainText"><o:p>&nbsp;</o:p></div>  <div class="MsoPlainText"><span style="">&nbsp; </span>grant select on xx_tax to user;<o:p></o:p></div>  <div class="MsoPlainText"><span style="">&nbsp; </span>grant select on xx_trip to user;<o:p></o:p></div>  <div
 class="MsoPlainText"><span style="">&nbsp; </span>grant select on xx_foo to user;<o:p></o:p></div>  <div class="MsoPlainText"><o:p>&nbsp;</o:p></div>  <div class="MsoPlainText">Is there a way to grant to all tables, with a single grant?<span style="">&nbsp; </span>I know how<o:p></o:p></div>  <div class="MsoPlainText">to do it in mysql, but not postgres.<span style="">&nbsp; </span>As close as I get it:<o:p></o:p></div>  <div class="MsoPlainText"><o:p>&nbsp;</o:p></div>  <div class="MsoPlainText">#grant select on database demo to user<o:p></o:p></div>  <div class="MsoPlainText">ERROR:<span style="">&nbsp; </span>invalid privilege type SELECT for database<o:p></o:p></div>  <div class="MsoPlainText"><o:p>&nbsp;</o:p></div>  <div class="MsoPlainText">-- <o:p></o:p></div>  <div class="MsoPlainText">----<o:p></o:p></div>  <div class="MsoPlainText">Visit http://www.obviously.com/<o:p></o:p></div>  <div class="MsoPlainText"><o:p>&nbsp;</o:p></div>  <div
 class="MsoPlainText"><o:p>&nbsp;</o:p></div>  <div class="MsoPlainText"><o:p>&nbsp;</o:p></div>  <div class="MsoPlainText">---------------------------(end of broadcast)---------------------------<o:p></o:p></div>  <div class="MsoPlainText">TIP 9: In versions below 8.0, the planner will ignore your desire to<o:p></o:p></div>  <div class="MsoPlainText"><span style="">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>choose an index scan if your joining column's datatypes do not<o:p></o:p></div>  <div class="MsoPlainText"><span style="">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>match<o:p></o:p></div>  <div class="MsoPlainText"><o:p>&nbsp;</o:p></div>  <div class="MsoPlainText"><o:p>&nbsp;</o:p></div>  <div class="MsoPlainText">-- <o:p></o:p></div>  
--0-213577103-1146629277=:4621--