X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 48781D9A78 for ; Wed, 28 Sep 2005 07:55:17 -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 70326-08 for ; Wed, 28 Sep 2005 10:55:12 +0000 (GMT) Received: from mars.amiindia.co.in (unknown [203.199.198.229]) by svr1.postgresql.org (Postfix) with ESMTP id C50E9D9A6B for ; Wed, 28 Sep 2005 07:55:05 -0300 (ADT) Received: from amiindiahjwbgh ([10.0.0.205]) (authenticated bits=0) by mars.amiindia.co.in (8.12.10/8.12.11) with ESMTP id j8SAqQfT000347; Wed, 28 Sep 2005 16:22:26 +0530 Message-ID: <021201c5c41c$1df597d0$cd00000a@amiindiahjwbgh> From: "sandhya" To: "bramhe manoj" Cc: "postgre" References: <20050928102445.52912.qmail@web51607.mail.yahoo.com> Subject: Re: database access queries Date: Wed, 28 Sep 2005 16:32:28 +0530 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1437 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.047 required=5 tests=[AWL=-0.003, FORGED_RCVD_HELO=0.05] X-Spam-Level: X-Archive-Number: 200509/301 X-Sequence-Number: 19038 ----- Original Message ----- From: "bramhe manoj" To: Sent: Wednesday, September 28, 2005 3:54 PM Subject: [ADMIN] database access queries > hi , > > we are working as linux administrators in enng college > in mumbai(india). > > we have created databases in postgresql for all staffs > & students & granted them with permissions & password Are all users have superuser permission ? > > query : > > how to restrict database user from accessing other > users databases? Accessing other user's database......IS it mean getting the table info of other user's database? > > here we are getting problem that any user can access > database of other users > > pls tell us how we can do in postgresql See: \du List of database users User name | User ID | Attributes -----------+---------+---------------------------- postgres | 1 | superuser, create database root | 100 | superuser, create database sampledb | 103 | If you have a user of 'sampledb' with no superuser permission..he can't access the tables of other user's database. Check the permissions and the login info. > > bye > > > prof bramhe > prof pandagre > > > > __________________________________ > Yahoo! Mail - PC Magazine Editors' Choice 2005 > http://mail.yahoo.com > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster