Received: from stubee.d2hosting.net ([66.70.41.160]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f9QJx6P98323 for ; Fri, 26 Oct 2001 15:59:06 -0400 (EDT) (envelope-from tswan-lst@ics.olemiss.edu) Received: from ics.olemiss.edu (d2interactive.sairinc.com [12.6.178.90]) by stubee.d2hosting.net (8.11.6/linuxconf) with ESMTP id f9QJwum24151; Fri, 26 Oct 2001 14:58:57 -0500 Message-ID: <3BD9C080.2070008@ics.olemiss.edu> Date: Fri, 26 Oct 2001 14:58:56 -0500 From: Thomas Swan User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:0.9.5+) Gecko/20011026 X-Accept-Language: en-us MIME-Version: 1.0 To: Steve Brett CC: pgsql-sql@postgresql.org Subject: Re: Granting database level permissions... References: <3BCF3146.4090504@olemiss.edu> <9qool6$1dj8$1@news.tht.net> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Archive-Number: 200110/387 X-Sequence-Number: 5339 > Steve Brett wrote: > >have a look at pg_hba.conf in your data dir. it's all in there. > >Steve > >"Thomas Swan" wrote in message >news:3BCF3146.4090504@olemiss.edu... > >>Is it possible to grant database level access to a user in PostgreSQL? >> >>I have created a user and database, and I want the user to have full >>control over that database. I have been through the online docs and >>news groups but have not found a statement or answer to the question. >> >>Thomas >> >> >> >>---------------------------(end of broadcast)--------------------------- >>TIP 4: Don't 'kill -9' the postmaster >> The problem is not in access to psql. pg_hba.conf only controls that portion or controls access to a database if a local user. I want to do the equivalent of a GRANT ALL on {database_name} TO {username}; If I want to allow a user to create a table on the database, I cannot do that and restrict them only to the specified database. Currently they would have to have created the database to have full rights on it. Besides, if I want to have two users have full rights on a database, I can't do that if I can only have one owner...