I want to write a program so that users go to a web site and they can
request to see data that is stored on a database that is stored on the web
server. This will be on a commercial ISP and not a dedicated corporate
server.
Each user can enter data about themselves that gets stored in the database
and can dictate who can see and who can't see that data.
Hence although users can edit their own database data they should not be
able to download it or open it in a database program like access and see
what others do not want them to see. They can see what others have put in
the database but only if the person entering the data has added them to
their list of valid viewers.
I am assuming Indy components can do what I want but I have only ever done
simple file reading with IdHTTP before and do not know where to start with
reading and writing to a database with Indy (I can do it in Delphi using
ADO). So my questions are:
What is the best way to go about this?
Which Indy components should I read about?
Are there any tutorials that may be useful?
How do I make sure the database is secure from those trying to read what
others want to keep private to a small group of users?
Many thanks if you can help.
