Hi, I'm creating a system that allows a webmaster to create users and databases. They can then assign what users can access what databases. There are other tools too but basically involving the scripts creating directories, new files etc. Users can also write to the databases when given access. I want to know the best layout for this.
Currently my file structure is,
/cgi-bin/scripts.pl
/databases/dbase1/temp.dat
/databases/dbase2/temp.dat ect..
/users/A.dat
/users/B.dat (each letter stores all users beginning with it along with their passwords and email addresses)

The problem I seem to have is...
1. I don't want anyone being able to just grab the files that store all my users with their details and passwords. It seems that unless I have /users set to 0777 i cant add files new files to it via my script. It is the same with /databases I want to be able to create new databases inside AND let users write to the databases. But I dont want someone just finding /databases/dbase1/temp.dat and taking the data. I was thinking htaccess but then i need to give each user their own??
I've read around and I can't seem to find anywhere that suggest a good way for doing this.
Would really appreciate some help off you clever bunch of people. Thanks, Adam

In reply to Data Security in Perl by Anonymous Monk

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.