From: Jim Seach <jws22@bellatlantic.net>
To: Frederic boucher <dziablo@hotmail.com>
To: pgsql-sql@postgreSQL.org
Subject: Re: [SQL] Accessing other database...
Date: Fri, 5 Nov 1999 09:13:20 -0500
Message-ID: <004101bf2797$ea3bdd40$0a00a8c0@ws1> (raw)
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
>
>************
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: jws22@bellatlantic.net, dziablo@hotmail.com
Subject: Re: [SQL] Accessing other database...
In-Reply-To: <004101bf2797$ea3bdd40$0a00a8c0@ws1>
References: <004101bf2797$ea3bdd40$0a00a8c0@ws1>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox