Thread: 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/

Hi,<br /><br />You could easily generate a script with the list of tables and the required grant information and then
runit 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,
May03, 2006 9:03 AM<br /> To: pgsql-sql@postgresql.org<br /> Subject: [SQL] grant select on database demo to
user</div><divclass="MsoPlainText"> </div><div class="MsoPlainText">I find myself with long lists of tables</div><div
class="MsoPlainText"> </div><divclass="MsoPlainText"><span style="">  </span>grant select on xx_tax to user;</div><div
class="MsoPlainText"><spanstyle="">  </span>grant select on xx_trip to user;</div><div class="MsoPlainText"><span
style=""> </span>grant select on xx_foo to user;</div><div class="MsoPlainText"> </div><div class="MsoPlainText">Is
therea way to grant to all tables, with a single grant?<span style="">  </span>I know how</div><div
class="MsoPlainText">todo it in mysql, but not postgres.<span style="">  </span>As close as I get it:</div><div
class="MsoPlainText"> </div><divclass="MsoPlainText">#grant select on database demo to user</div><div
class="MsoPlainText">ERROR:<spanstyle="">  </span>invalid privilege type SELECT for database</div><div
class="MsoPlainText"> </div><divclass="MsoPlainText">-- </div><div class="MsoPlainText">----</div><div
class="MsoPlainText">Visithttp://www.obviously.com/</div><div class="MsoPlainText"> </div><div
class="MsoPlainText"> </div><divclass="MsoPlainText"> </div><div class="MsoPlainText">---------------------------(end
ofbroadcast)---------------------------</div><div class="MsoPlainText">TIP 9: In versions below 8.0, the planner will
ignoreyour desire to</div><div class="MsoPlainText"><span style="">       </span>choose an index scan if your joining
column'sdatatypes do not</div><div class="MsoPlainText"><span style="">       </span>match</div><div
class="MsoPlainText"> </div><divclass="MsoPlainText"> </div><div class="MsoPlainText">-- </div> 

am  02.05.2006, um 20:32:54 -0700 mailte Bryce Nesbitt folgendes:
> 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

No, but you can use a little Script, please read:
http://people.planetpostgresql.org/greg/index.php?/archives/38-guid.html#extended

HTH, Andreas
-- 
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47215,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net===    Schollglas Unternehmensgruppe    === 

A. Kretschmer wrote:
> Is there a way to grant to all tables, with a single grant?  I know how
>   
>
> No, but you can use a little Script, please read:
> http://people.planetpostgresql.org/greg/index.php?/archives/38-guid.html#extended
>
> HTH, Andreas
>   
Thanks,
What always happens is I create a new view, or replace an old view, and
the grant step
gets forgotten.  Then I get angry users who can't see the view (I can
see it, just they can't)....                                       -Bryce