| 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: | 1053880478.1120.4.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 |
| 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? |