Thread: Set Privileges on All Tables (and/or Sequences) at Once

Set Privileges on All Tables (and/or Sequences) at Once

From
Date:
Set Privileges on All Tables (and/or Sequences) at
Once

Can this be done?  or am i stuck doing this on each
table and sequence whenever i create a new group?

tia...



__________________________________
Yahoo! Mail - PC Magazine Editors' Choice 2005
http://mail.yahoo.com

Re: Set Privileges on All Tables (and/or Sequences) at

From
Sean Davis
Date:
On 10/7/05 1:20 PM, "operationsengineer1@yahoo.com"
<operationsengineer1@yahoo.com> wrote:

> Set Privileges on All Tables (and/or Sequences) at
> Once
>
> Can this be done?  or am i stuck doing this on each
> table and sequence whenever i create a new group?
>
> tia...

See here:

http://archives.postgresql.org/pgsql-novice/2005-10/msg00018.php

Sean


Re: Set Privileges on All Tables (and/or Sequences) at Once

From
John DeSoi
Date:
On Oct 7, 2005, at 1:20 PM, <operationsengineer1@yahoo.com>
<operationsengineer1@yahoo.com> wrote:

> Set Privileges on All Tables (and/or Sequences) at
> Once
>
> Can this be done?  or am i stuck doing this on each
> table and sequence whenever i create a new group?

There are some functions here which can do this for you en masse.

http://pgedit.com/node/20






John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL


Re: Set Privileges on All Tables (and/or Sequences) at Once

From
"Derrick Betts"
Date:
The pgAdmin III application allows for this. Try http://www.pgadmin.org/

Derrick

----- Original Message -----
From: <operationsengineer1@yahoo.com>
To: <pgsql-novice@postgresql.org>
Sent: Friday, October 07, 2005 11:20 AM
Subject: [NOVICE] Set Privileges on All Tables (and/or Sequences) at Once


> Set Privileges on All Tables (and/or Sequences) at
> Once
>
> Can this be done?  or am i stuck doing this on each
> table and sequence whenever i create a new group?
>
> tia...
>
>
>
> __________________________________
> Yahoo! Mail - PC Magazine Editors' Choice 2005
> http://mail.yahoo.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>       choose an index scan if your joining column's datatypes do not
>       match
>
>