Example Re: SELECT across multiple db

From: Nabil Sayegh <postgresql(at)e-trolley(dot)de>
To: Chris Boget <chris(at)wild(dot)net>
Cc: pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Example Re: SELECT across multiple db
Date: 2003-05-25 16:34:38
Message-ID: 1053880477.1073.2.camel@billy
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I send this to the list, because the mail to chris(at)wild(dot)net just returned.

---

I attached an example with privileges.

It has 3 schema (in this case, all have the same structure, but these
could be of different structure, too):

schema db1 - user db1
schema db2 - user db2
schema db3 - user db3
noschema - user dbx

dbx is allowed to select from schema db1/table nav1 and db2/table nav1
but is not allowed to select from schema db3

At the end of the example there are 2 simple tests.

HIH
--
e-Trolley Sayegh & John, Nabil Sayegh
Tel.: 0700 etrolley /// 0700 38765539
Fax.: +49 69 8299381-8
PGP : www.e-trolley.de

Attachment Content-Type Size
example.sql text/x-sql 4.0 KB

Browse pgsql-novice by date

  From Date Subject
Next Message nolan 2003-05-25 16:41:09 Re: psql without password
Previous Message Bruno Wolff III 2003-05-25 13:56:30 Re: [PHP] Case Insensitive Searching?