X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id AC11ED1B241 for ; Sun, 18 Jul 2004 16:52:48 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 51092-08 for ; Sun, 18 Jul 2004 19:52:43 +0000 (GMT) Received: from sccrmhc12.comcast.net (sccrmhc12.comcast.net [204.127.202.56]) by svr1.postgresql.org (Postfix) with ESMTP id 96F7BD1B23E for ; Sun, 18 Jul 2004 16:52:40 -0300 (ADT) Received: from [65.34.209.198] (c-65-34-209-198.se.client2.attbi.com[65.34.209.198]) by comcast.net (sccrmhc12) with SMTP id <2004071819524101200fk9nke>; Sun, 18 Jul 2004 19:52:41 +0000 User-Agent: Microsoft-Entourage/10.1.4.030702.0 Date: Sun, 18 Jul 2004 15:52:41 -0400 Subject: Re: How do I grant access to entire database at From: Randall Perry To: Peter Eisentraut , Ulrich Meis , Message-ID: In-Reply-To: <200405172110.08207.peter_e@gmx.net> Mime-version: 1.0 Content-type: text/plain; charset="US-ASCII" Content-transfer-encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.1 tagged_above=0.0 required=5.0 tests=RCVD_IN_SORBS X-Spam-Level: X-Archive-Number: 200407/206 X-Sequence-Number: 14274 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/