Greetings folks;

I have a large project coming up which has a slightly strange request on the table. The project is a custom accounting/management system, with a CGI interface and RDBMS back-end as one would expect.
The chap I'm writing this for is somewhat paranoid (Having worked for a PKI/digital certificate company) and wants me to be able to split, or rather replicate, only part of the database for customer manipulation.

It works like this:
The management system is naturally all accessable by the Administrator. However parts are accessable by customers, so they are able to set up their own accounts if they choose to.
Instead of having some reasonably simple set of CGIs with, if you'll pardon the over-dramatic phrasing, security clearance checks to see who is an Administrator, and who can only access their own personal information, The Man wants something quite different.
He wants to have the entire database and software on one server, and then have PART of the database replicated in a second database on a second server with only a subset of the management CGIs. This second server's DB will only contain information about the users and none of the accounting information, and the CGIs will only be able to modify the users accounts accordingly.

I understand his wants to separate the accounting system out to make it more "secure" - and I can work out a basic system of dualled CGIs and various replicated DB tables... But I'm not sure its the best way to deal with this problem.

What does the Monk population think?

Cheers,
JP

-- Alexander Widdlemouse undid his bellybutton and his bum dropped off --

In reply to Twin interfaces, and one and a half databases to a project by JPaul

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.