From: | "George Pavlov" <gpavlov(at)mynewplace(dot)com> |
---|---|
To: | "Robert James" <srobertjames(at)gmail(dot)com>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Privs on deleted objects |
Date: | 2007-05-17 23:45:30 |
Message-ID: | 8C5B026B51B6854CBE88121DBF097A86BA3E3E@ehost010-33.exch010.intermedia.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
no and no. a script looping through all tables (using
information_schema/pg_catalog info) is not that difficult to write
though.
> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org
> [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Robert James
> Sent: Thursday, May 17, 2007 4:23 PM
> To: pgsql-general(at)postgresql(dot)org
> Subject: [GENERAL] Privs on deleted objects
>
> 1. Is there anyway to give a role privs on a certain table,
> delete that table, recreate it, and have those privs persist?
>
> 2. Is there anyway to give a role privs to all tables in a
> database, without having to name each one individually? Can I
> use this to apply to tables created later on?
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Paul Ramsey | 2007-05-17 23:55:51 | Re: 8.0, UTF8, and CLIENT_ENCODING |
Previous Message | Robert James | 2007-05-17 23:22:57 | Privs on deleted objects |