X-Original-To: pgsql-admin@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 43E2647580B for ; Mon, 12 May 2003 17:24:13 -0400 (EDT) Received: from news.hub.org (news.hub.org [64.49.215.80]) by postgresql.org (Postfix) with ESMTP id BC786474E42 for ; Mon, 12 May 2003 17:24:12 -0400 (EDT) Received: by news.hub.org (Postfix, from userid 8) id A8DAA43A89E; Mon, 12 May 2003 17:24:12 -0400 (EDT) X-Newsgroups: comp.databases.postgresql.admin From: Travis Whitton Subject: Grant Question Message-ID: User-Agent: slrn/0.9.7.4 (Linux) Lines: 46 X-Complaints-To: abuse@usenetserver.com X-Abuse-Info: Please be sure to forward a copy of ALL headers X-Abuse-Info: Otherwise we will be unable to process your complaint properly. Date: Mon, 12 May 2003 21:11:47 GMT To: pgsql-admin@postgresql.org X-Spam-Status: No, hits=-6.6 required=5.0 tests=BAYES_01,USER_AGENT version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200305/165 X-Sequence-Number: 8727 Hi - I'm new to postgreSQL, and I'm having some issues with using GRANT. I'm looking for a way to grant privileges on all tables in a given database to a user. I can accomplish this using individual grant statements for each table; however, a global grant is not working for me. Here's an example. template1=# CREATE DATABASE dummy; CREATE DATABASE edit=# \c dummy; You are now connected to database dummy. dummy=# CREATE TABLE test (id int); CREATE TABLE dummy=# CREATE TABLE test2 (id int); CREATE TABLE dummy=# GRANT ALL ON DATABASE dummy TO devel; GRANT dummy=# \dp Access privileges for database "dummy" Schema | Table | Access privileges --------+-------+------------------- public | test | public | test2 | (2 rows) No privileges... dummy=# GRANT ALL ON test TO devel; GRANT dummy=# \dp Access privileges for database "dummy" Schema | Table | Access privileges --------+-------+------------------------------------ public | test | {=,postgres=arwdRxt,devel=arwdRxt} public | test2 | (2 rows) This works but only by referencing a specific table. Any help would be appreciated. Thanks, Travis Whitton