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: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] 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? > > ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
