Re: granting all to user

From: "Nick Fankhauser" <nickf(at)ontko(dot)com>
To: "Jodi Kanter" <jkanter(at)virginia(dot)edu>, "Postgres Admin List" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: granting all to user
Date: 2002-01-07 21:22:07
Message-ID: NEBBLAAHGLEEPCGOBHDGCEHKECAA.nickf@ontko.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

There's no command to essentially grant <priv> on all to a user, but it's
pretty easy to write a select that produces a bunch of grant statements for
you based on the system tables. then you log the results & run them...

-Nick

> -----Original Message-----
> From: pgsql-admin-owner(at)postgresql(dot)org
> [mailto:pgsql-admin-owner(at)postgresql(dot)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
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Jodi Kanter 2002-01-07 21:25:15 unknown index
Previous Message Jodi Kanter 2002-01-07 21:01:43 granting all to user