Thread: 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?

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@postgresql.org
> [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Robert James
> Sent: Thursday, May 17, 2007 4:23 PM
> To: pgsql-general@postgresql.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?
>
>