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 1A3BF329D7F for ; Tue, 14 Sep 2004 19:46:57 +0100 (BST) 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 88453-05 for ; Tue, 14 Sep 2004 18:46:54 +0000 (GMT) Received: from letsche.net (wuw-xuvktmzw.dybb.com [216.203.97.204]) by svr1.postgresql.org (Postfix) with SMTP id 7DE44329C67 for ; Tue, 14 Sep 2004 19:46:54 +0100 (BST) Received: (qmail 16039 invoked by uid 518); 14 Sep 2004 13:46:50 -0500 Received: from localhost (sendmail-bs@127.0.0.1) by localhost with SMTP; 14 Sep 2004 13:46:50 -0500 Date: Tue, 14 Sep 2004 13:46:49 -0500 (CDT) From: Terry Letsche To: pgsql-admin@postgresql.org Subject: Setup for a db class Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200409/127 X-Sequence-Number: 14830 Hi. I'm running postgresql on a Debian box, and plan to use it for teaching a database class. While installing some graphical tools for the students (namely pgadmin3), I discovered that the students could see each other's work by simply browsing to someone else's database. What am I missing on permissions? Each student's database is set to be owned by them, but the contents are still browsable. Any suggestions on configuration for a similar lab situation are welcome! Terry -- Terry Letsche | http://terry.letsche.net | terry at letsche dot net