Hi Brian,

If i'm not mistaken and recall correctly, access rights / authorization are per table, not per schema - at least in MonetDB; hence, you'd have to grant access for each table in other than the user's schema separately.

Best,
Stefan

On June 22, 2015 8:45:08 PM CEST, Brian Hood <brianh6854@googlemail.com> wrote:

Hi All,

There is something I have pondered on is there a way to have a username that can be authorized for multiple schemas under your dbfarm.

If not what is the reason ?

I haven't seen a way to do this so far.

Regards,

Brian Hood
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list

--
| Stefan.Manegold@CWI.nl | DB Architectures (DA) |
| www.CWI.nl/~manegold/ | Science Park 123 (L321) |
| +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |