On Tuesday 03 Dec 2002 11:23 pm, Joe Conway wrote:
> Bruno Wolff III wrote:
> > On Mon, Dec 02, 2002 at 18:44:03 -0800,
> >
> > "j.random.programmer" <javadesigner@yahoo.com> wrote:
> >>5) There is no way to grant permissions on all tables
> >>within a database to some user. You have to grant
> >>permissions on each table one-by-one. What I want
> >>to do (and mysql allows this) is something like:
> >>
> >>GRANT ALL on foodb.* to user_bar;
> >
>
> For example (not heavily tested!)
[snipped plpgsql grantall function from Joe]
There are two examples on how to do this in my Postgresql Notes at
techdocs.postgresql.org (one shellscript, one plpgsql) and I think it's also
a utility in Roberto's cookbook. Been there 12 months at least.
--
Richard Huxton