This is a pain. Couldn't we gave something simple like GRANT ALL ON database.* TO JOE;
Which would grant full access to all objects in the database to JOE for all time? > Ulrich Meis wrote: >> 1. Write a script that queries the postgres internal tables for all >> tables,schemas,sequences,views,functions,... and then executes grant >> statements for each one of them. This would have to repeated each >> time a new object is created. > > Yes, that's the most popular method so far. You could also write a > stored procedure. > -- Randall Perry sysTame Xserve Web Hosting/Co-location Website Design/Development WebObjects Hosting Mac Consulting/Sales http://www.systame.com/ ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html