Example Re: SELECT across multiple db - Mailing list pgsql-novice

From Nabil Sayegh
Subject Example Re: SELECT across multiple db
Date
Msg-id 1053880478.1120.4.camel@billy
Whole thread Raw
List pgsql-novice
I send this to the list, because the mail to chris@wild.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

pgsql-novice by date:

Previous
From: Nabil Sayegh
Date:
Subject: Example Re: SELECT across multiple db
Next
From: nolan@celery.tssi.com
Date:
Subject: Re: psql without password