I should have just given you this example in my earlier reply- this is how I
quickly get a batch of grant statements- you can probably modify it for your
needs:
select 'grant select on '||relname||'to "www-data";' from pg_class where
relname not like 'pg%';
-Nick
> -----Original Message-----
> From: pgsql-admin-owner@postgresql.org
> [mailto:pgsql-admin-owner@postgresql.org]On Behalf Of Jodi Kanter
> Sent: Monday, January 07, 2002 4:02 PM
> To: Postgres Admin List
> Subject: [ADMIN] granting all to user
>
>
> Can I grant a user all privileges to all the tables without
> having to type a
> grant command for each table individually?
>
> I know that I can use:
> grant all on object to username
>
> but I would like to set this person up as a superuser for now so
> that he can
> assist with development.
>
> It appears that when I set up users the default is NOT to give them access
> to any of the tables. I would like to have the default set so
> that users can
> read all the tables and then have the option to give this one particular
> person full access.
>
> Any suggestions???
> thanks
> Jodi
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
