Re: grant select on database demo to user

From: Bryce Nesbitt <bryce1(at)obviously(dot)com>
To: "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>, pgsql-sql(at)postgresql(dot)org
Subject: Re: grant select on database demo to user
Date: 2006-05-06 19:46:13
Message-ID: 445CFD05.5070808@obviously.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Ben K. 2006-05-06 20:05:36 Re: Returning String as Integer
Previous Message Stephan Szabo 2006-05-06 18:57:39 Re: problem with uniques and foreing keys