pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Accessing other database...
8+ messages / 3 participants
[nested] [flat]

* Accessing other database...
@ 1999-11-04 07:36 Frederic boucher <dziablo@hotmail.com>
  1999-11-05 08:46 ` Re: [SQL] Accessing other database... Stoyan Genov <genov@digsys.bg>
  0 siblings, 1 reply; 8+ messages in thread

From: Frederic boucher @ 1999-11-04 07:36 UTC (permalink / raw)
  To: pgsql-sql

Is it possible to acess another database from a database..?  Like SHEMA in 
oracle?  Because, otherwise it meens that all my users should use the same 
database and see (without being able to select) the others tables, 
views,etc..

I've tried something like :

select * from databasename.tablename;

but...  it does not work...  is there a way around to do this?


______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com



^ permalink  raw  reply  [nested|flat] 8+ messages in thread

* Re: [SQL] Accessing other database...
  1999-11-04 07:36 Accessing other database... Frederic boucher <dziablo@hotmail.com>
@ 1999-11-05 08:46 ` Stoyan Genov <genov@digsys.bg>
  0 siblings, 0 replies; 8+ messages in thread

From: Stoyan Genov @ 1999-11-05 08:46 UTC (permalink / raw)
  To: Frederic boucher <dziablo@hotmail.com>; +Cc: pgsql-sql

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




^ permalink  raw  reply  [nested|flat] 8+ messages in thread

* Re: [SQL] Accessing other database...
@ 1999-11-05 05:16 Frederic boucher <dziablo@hotmail.com>
  1999-11-06 12:13 ` Re: [SQL] Accessing other database... Stoyan Genov <genov@digsys.bg>
  0 siblings, 1 reply; 8+ messages in thread

From: Frederic boucher @ 1999-11-05 05:16 UTC (permalink / raw)
  To: pgsql-sql

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



^ permalink  raw  reply  [nested|flat] 8+ messages in thread

* Re: [SQL] Accessing other database...
  1999-11-05 05:16 Re: [SQL] Accessing other database... Frederic boucher <dziablo@hotmail.com>
@ 1999-11-06 12:13 ` Stoyan Genov <genov@digsys.bg>
  0 siblings, 0 replies; 8+ messages in thread

From: Stoyan Genov @ 1999-11-06 12:13 UTC (permalink / raw)
  To: Frederic boucher <dziablo@hotmail.com>; +Cc: pgsql-sql

Hi.

If there is a will, there is a way ;-)

Please revise the VIEWS concept.

Sorry for the brief answer - I'm a little bit in a hurry. More to follow.

Stoyan Genov




^ permalink  raw  reply  [nested|flat] 8+ messages in thread

* Re: [SQL] Accessing other database...
@ 1999-11-05 07:09 Frederic boucher <dziablo@hotmail.com>
  0 siblings, 0 replies; 8+ messages in thread

From: Frederic boucher @ 1999-11-05 07:09 UTC (permalink / raw)
  To: pgsql-sql

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



^ permalink  raw  reply  [nested|flat] 8+ messages in thread

* Re: [SQL] Accessing other database...
@ 1999-11-05 14:13 Jim Seach <jws22@bellatlantic.net>
  0 siblings, 0 replies; 8+ messages in thread

From: Jim Seach @ 1999-11-05 14:13 UTC (permalink / raw)
  To: Frederic boucher <dziablo@hotmail.com>; pgsql-sql

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
>
>************
>




^ permalink  raw  reply  [nested|flat] 8+ messages in thread

* Re: [SQL] Accessing other database...
@ 1999-11-06 09:45 Frederic boucher <dziablo@hotmail.com>
  1999-11-07 10:50 ` Re: [SQL] Accessing other database... Stoyan Genov <genov@digsys.bg>
  0 siblings, 1 reply; 8+ messages in thread

From: Frederic boucher @ 1999-11-06 09:45 UTC (permalink / raw)
  To: pgsql-sql

Except for the idea someone give yesterday... I cannot see what could I do 
with view... So I'll be waiting your answer impatiently! :)

\fb

>
>Hi.
>
>If there is a will, there is a way ;-)
>
>Please revise the VIEWS concept.
>
>Sorry for the brief answer - I'm a little bit in a hurry. More to follow.
>
>Stoyan Genov
>

______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com



^ permalink  raw  reply  [nested|flat] 8+ messages in thread

* Re: [SQL] Accessing other database...
  1999-11-06 09:45 Re: [SQL] Accessing other database... Frederic boucher <dziablo@hotmail.com>
@ 1999-11-07 10:50 ` Stoyan Genov <genov@digsys.bg>
  0 siblings, 0 replies; 8+ messages in thread

From: Stoyan Genov @ 1999-11-07 10:50 UTC (permalink / raw)
  To: Frederic boucher <dziablo@hotmail.com>; +Cc: pgsql-sql

Hi.

Sorry for me missing something in the dialogue (trialogue) - "Jim Seach" 
<jws22@bellatlantic.net> has explained very clearly what I had in mind 
about the VIEWS. Unfortunately, I cannot think out a better way of 
separating users'
data than views building for now.

Anyway, if something enlightens me, you'll know it.

Stoyan Genov




^ permalink  raw  reply  [nested|flat] 8+ messages in thread


end of thread, other threads:[~1999-11-07 10:50 UTC | newest]

Thread overview: 8+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-11-04 07:36 Accessing other database... Frederic boucher <dziablo@hotmail.com>
1999-11-05 08:46 ` Stoyan Genov <genov@digsys.bg>
1999-11-05 05:16 Re: [SQL] Accessing other database... Frederic boucher <dziablo@hotmail.com>
1999-11-06 12:13 ` Stoyan Genov <genov@digsys.bg>
1999-11-05 07:09 Re: [SQL] Accessing other database... Frederic boucher <dziablo@hotmail.com>
1999-11-05 14:13 Re: [SQL] Accessing other database... Jim Seach <jws22@bellatlantic.net>
1999-11-06 09:45 Re: [SQL] Accessing other database... Frederic boucher <dziablo@hotmail.com>
1999-11-07 10:50 ` Stoyan Genov <genov@digsys.bg>

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