Received: from hotmail.com (law2-f93.hotmail.com [216.32.181.93]) by hub.org (8.9.3/8.9.3) with SMTP id KAA56405 for ; Fri, 5 Nov 1999 10:10:08 -0500 (EST) (envelope-from dziablo@hotmail.com) Received: (qmail 63595 invoked by uid 0); 5 Nov 1999 15:09:37 -0000 Message-ID: <19991105150937.63594.qmail@hotmail.com> Received: from 207.96.139.35 by www.hotmail.com with HTTP; Fri, 05 Nov 1999 07:09:37 PST X-Originating-IP: [207.96.139.35] From: "Frederic boucher" To: pgsql-sql@postgreSQL.org Subject: Re: [SQL] Accessing other database... Date: Fri, 05 Nov 1999 07:09:37 PST Mime-Version: 1.0 Content-Type: text/plain; format=flowed I'll probably have to do something like that... But the table will still contains the data off all the users. Since, unlike my first example, there will be a lot more than 2 users, the action (update,select,add,delete) will be much slower than if only the good records would be in the table. if I do something like : delete from TheTable; or delete from TheTable where User_ID = THE_ID the first will be faster even with an index on UserID. And deleting all data is a "simple" action... I'm not talking about more complicated actions. \fb Thanks for your help and if you have an other idea... don't hesitate! > >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 > > > >************ > > > > ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com