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.
Show quoted text
-----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 objects1. 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?