Running 2 Identical Databases

[RobR]

Anyone know if it is possble to run two identical databases? One will be "read only" using the Web Security Database privileges, whereas the other will be "read and write." Changes made to the read/write database should be automatically written to the read-only database.

Can this be accomplished in a simple, straightfoward manner?

[transpower]

Why not just change the read/write privileges as appropriate? Some users will just have read privileges (like guests); others will have read/write privileges.

[Vaughan]

I guess the question is, why? What is it you are really trying to achieve?

[RobR]

This relates to my post a few days ago: When using the Web Security Database to control login/passwords for "member" users, there is no was to allow general users/non-members to have limited search privileges while giving members full access privileges. Consquently, I've had to enable full access privileges for "All Users" to allow for a dynamic homepage visible to all web users while using a false "-edit" command to prompt a login when members navigate to a "member-only" area.

See my site and it will be apparent: www.design-calendar.com

As you pointed out, Vaughan, this is inartful, but I'll be darned if I know a better way. I thought I could run two identical DBs with different access privs. Just brainstorming now.

Best, RR

[Vaughan]

It may be that CDML and CWP is not the right tool for the job. Maybe FMP 7? or maybe MySQL and PHP, but that's a whole different league of technologies.

[Garry Claridge]

If you are running the database on OS X you can use a little bit of PHP to control access. (You do not need FX to do this!)

All the best.

Garry

[RobR]

Okay. Thanks, fellas.