Received: from smtp-out1.bellatlantic.net (smtp-out1.bellatlantic.net [199.45.39.156]) by hub.org (8.9.3/8.9.3) with ESMTP id JAA46778 for ; Fri, 5 Nov 1999 09:12:46 -0500 (EST) (envelope-from jws22@bellatlantic.net) Received: from ws1 (adsl-151-200-16-197.bellatlantic.net [151.200.16.197]) by smtp-out1.bellatlantic.net (8.9.1/8.9.1) with SMTP id JAA14711; Fri, 5 Nov 1999 09:11:04 -0500 (EST) Message-ID: <004101bf2797$ea3bdd40$0a00a8c0@ws1> From: "Jim Seach" To: "Frederic boucher" , Subject: Re: [SQL] Accessing other database... Date: Fri, 5 Nov 1999 09:13:20 -0500 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 4.72.3110.1 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3 One thing you might want to do is to create the first (shared) table as you do now. For the second table (different info for each user), create the table as you planned but add a column to identify the user. You can then create a view on this second table to filter out rows based on the user's login id, so they will only see their own records. Will this work for your application? Jim Seach -----Original Message----- From: Frederic boucher To: pgsql-sql@postgreSQL.org Date: Friday, November 05, 1999 8:30 AM Subject: Re: [SQL] Accessing other database... >Ok so what can I do if I would like 2 user to have two tables. The first >tabl would be a common table for both user (with the same synch data) and >the other one would be the same "table_name" but each user would see >different records? > >is this kind of thing possible? > >\fb > >Thanks >>In-reply-to: Your message of "Thu, 04 Nov 1999 07:36:56 PST." >><19991104153657.40198.qmail@hotmail.com> >> >>Hello, >> >>It is NOT possible to access another database from a database. >>Is the case so specific that you cannot create different databases for the >>different groups of users? Doing this, you can fairly easy regulate users' >>access to databases through GRANT/REVOKE and pg_hba.conf >> >>Stoyan Genov >> > >______________________________________________________ >Get Your Private, Free Email at http://www.hotmail.com > >************ >