X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id B7B175E3631 for ; Fri, 27 Aug 2004 10:03:42 -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 94767-05 for ; Fri, 27 Aug 2004 13:03:38 +0000 (GMT) Received: from acten.itcnet.ro (unknown [193.231.172.14]) by svr1.postgresql.org (Postfix) with ESMTP id A3AC35E46CF for ; Fri, 27 Aug 2004 10:03:35 -0300 (ADT) Received: from acten.itcnet.ro (localhost.localdomain [127.0.0.1]) by acten.itcnet.ro (8.12.6-20030917/8.12.6) with ESMTP id i7RCUWIe027234 for ; Fri, 27 Aug 2004 15:30:33 +0300 Received: (from apache@localhost) by acten.itcnet.ro (8.12.6-20030917/8.12.6/Submit) id i7RCUWCw027233; Fri, 27 Aug 2004 15:30:32 +0300 Message-Id: <200408271230.i7RCUWCw027233@acten.itcnet.ro> Received: from client 81.196.16.98 for UebiMiau2.7 (webmail client); Fri, 27 Aug 2004 15:30:32 -0000 Date: Fri, 27 Aug 2004 15:30:32 -0000 From: "Nosyman" To: pgsql-sql@postgresql.org Reply-To: "Nosyman" Subject: GRANT ON all tables X-Priority: 3 X-Mailer: X-Original-IP: 81.196.16.98 Content-Transfer-Encoding: 8bit X-MSMail-Priority: Medium Importance: Medium Content-Type: text/plain; charset="iso-8859-1"; MIME-Version: 1.0 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=2.7 tagged_above=0.0 required=5.0 tests=MISSING_MIMEOLE, MSGID_FROM_MTA_HEADER, PRIORITY_NO_NAME X-Spam-Level: ** X-Archive-Number: 200408/301 X-Sequence-Number: 18798 Hi there, I need to know how can I give privileges to all the tables in a database. For example, I have one database named "test" .This database contains about 30 tables. I want to grant SELECT and DELETE privileges to the 'test_user' by typing GRANT .... just once (something like GRANT SELECT, DELETE ON all_tables TO test_user). It is possible? I search PostgreSQL docs and I can't find out... Thanks Nosy _________________________________________________________________ Message sent using ITCNet free webmailer (http://www.easymail.ro)