Received: from tnt.diff.org ([62.98.66.239]) by hub.org (8.10.1/8.11.0) with ESMTP id e9ODuBr76570 for ; Tue, 24 Oct 2000 09:56:14 -0400 (EDT) (envelope-from nonsolosoft@diff.org) Received: (from fer@localhost) by tnt.diff.org (8.11.1/8.9.3) id e9ODn9R80742; Tue, 24 Oct 2000 15:49:09 +0200 (CEST) (envelope-from nonsolosoft@diff.org) Date: Tue, 24 Oct 2000 15:49:09 +0200 (CEST) Message-Id: <200010241349.e9ODn9R80742@tnt.diff.org> X-Authentication-Warning: tnt.diff.org: fer set sender to nonsolosoft@diff.org using -f From: Ferruccio Zamuner To: pgsql-sql@hub.org Subject: Permission and users X-Archive-Number: 200010/205 X-Sequence-Number: 1867 Hi, PostgreSQL superuser (named A) create two different users: B: able to create db C: able to create db B creates db B_DB C creates db C_DB C is able to add tables at C_DB as well as at B_DB. B is able to add tables at B_DB as well ad at C_DB. How can I limit C to operate only to C_DB and B only to operate on B_DB? I can modify permission on C_DB to avoid read,modify for B user, but I'm not know how to exclude B to access to C_DB at all. Thank you in advance for any reply. \fer