I am using PHP Maker (homepage here) to generate webpage php reports from MySQL database. The problem is I don't know how to set user security level for what I need, which is :
user without login - any user from any host (read aby visitor to the website)should be able to query and/or display, export reports from the database tables trough the site interface
user with login - one user which can add, edit and/or delete records from the tables in the database.
Admin - my account as a supervisor
Can anyone give me a clue in designing the database ? Any suggestions are welcome. I am designing a web page for a Real-Estate business owned by a friend.