Re: grant select on database demo to user - Mailing list pgsql-sql

From Bryce Nesbitt
Subject Re: grant select on database demo to user
Date
Msg-id 445CFD05.5070808@obviously.com
Whole thread Raw
In response to Re: grant select on database demo to user  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
List 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



pgsql-sql by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: problem with uniques and foreing keys
Next
From: "Ben K."
Date:
Subject: Re: Returning String as Integer