Re: grant select on database demo to user

From: "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: grant select on database demo to user
Date: 2006-05-03 05:07:20
Message-ID: 20060503050720.GA26223@webserv.wug-glas.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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 ===

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Catalin Pitis 2006-05-03 05:08:22 Re: ERROR: plan should not reference subplan's variable
Previous Message Ben K. 2006-05-03 04:17:47 Re: Sorting aggregate column contents