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