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 4EB4F3A4DD4 for ; Mon, 10 Jan 2005 17:19:28 +0000 (GMT) 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 09374-10 for ; Mon, 10 Jan 2005 17:19:15 +0000 (GMT) Received: from out011.verizon.net (out011pub.verizon.net [206.46.170.135]) by svr1.postgresql.org (Postfix) with ESMTP id CC0F43A560D for ; Mon, 10 Jan 2005 17:19:14 +0000 (GMT) Received: from boojiboy.metrosplash.com ([66.15.181.204]) by out011.verizon.net (InterMail vM.5.01.06.06 201-253-122-130-106-20030910) with ESMTP id <20050110171913.LISH4717.out011.verizon.net@boojiboy.metrosplash.com> for ; Mon, 10 Jan 2005 11:19:13 -0600 Subject: Limiting user privileges From: Tad Marko To: pgsql-admin@postgresql.org Content-Type: text/plain Date: Mon, 10 Jan 2005 11:19:10 -0600 Message-Id: <1105377550.11245.0.camel@boojiboy.metrosplash.com> Mime-Version: 1.0 X-Mailer: Evolution 2.0.2 Content-Transfer-Encoding: 7bit X-Authentication-Info: Submitted using SMTP AUTH at out011.verizon.net from [66.15.181.204] at Mon, 10 Jan 2005 11:19:10 -0600 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 tagged_above=0 required=5 tests=FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200501/56 X-Sequence-Number: 15915 Howdy! I'm coming to postgresql from mysql, so I have a few preconceived notions that are causing me some trouble. Specifically, I'm trying to create users that have limited privileges on one database. It appears that by default, a new user has a lot of privileges all over all the databases. 1) How can I remove all privileges from all databases for a given user? 2) If I put back insert, delete and table creation privileges only on one database for a given user, will that user magically have all sorts of privileges on any databases that are created after doing #1 above? Thanks, Tad -- Tad Marko