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 <dziablo@hotmail.com>
>To: pgsql-sql@postgreSQL.org <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