thanks, by the way: all this usefull stuff is being captured in the designers knowledgebase on the design.mmbase.org site
Ernst -----Oorspronkelijk bericht----- Van: Rob van Maris [mailto:[EMAIL PROTECTED]] Verzonden: vrijdag 6 december 2002 16:29 Aan: [EMAIL PROTECTED] Onderwerp: Re: 2 instances of MMBase on 1 database? ----- Original Message ----- From: "Ernst Bunders" <[EMAIL PROTECTED]> > > -----Oorspronkelijk bericht----- > Van: Rob van Maris [mailto:[EMAIL PROTECTED]] > Verzonden: vrijdag 6 december 2002 13:28 > Aan: [EMAIL PROTECTED] > Onderwerp: Re: 2 instances of MMBase on 1 database? > > >Yes, you can configure the privileges in the database for the "slave" > server > >to have read-only access. > >At least to most tables, possibly all tables. > > How is this done, otherwise than configuring mmbase security? This is done by restricting access privileges granted to the mmbase user in the database. The details of how to do this vary accross database vendors, e.g. for MySQL this is done using the GRANT and REVOKE syntax. This way the access restriction is enforced by the database instead of by MMBase, wich makes it more robuust. Rob van Maris Developer Finalist IT Group Java Specialists ------------------------------------------------------------- Amsterdam, The Netherlands Office: +31 20 5962321 (Direct) Mobile: +31 651444006 Fax: +31 20 5962331 -------------------------------------------------------------
