Received: from student.cs.ucc.ie (student.cs.ucc.ie [143.239.211.125]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f1RE5Zx53851 for ; Tue, 27 Feb 2001 09:05:36 -0500 (EST) (envelope-from mcgee@student.cs.ucc.ie) Received: (from mcgee@localhost) by student.cs.ucc.ie (8.9.3/8.9.3) id OAA16033 for pgsql-php@postgresql.org; Tue, 27 Feb 2001 14:05:31 GMT From: Paul Joseph McGee Message-Id: <200102271405.OAA16033@student.cs.ucc.ie> Subject: Web Security To: pgsql-php@postgresql.org Date: Tue, 27 Feb 2001 14:05:31 +0000 (GMT) X-Mailer: ELM [version 2.5 PL2] MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200102/38 X-Sequence-Number: 177 Hi everybody, I am trying to implement a website where users may login and view available properties. Basically it is an online auctioneering site which is my final year project. I want to be able as SysAdmin to log in myself and modify, add properties, upload images etc. At the moment I am toying with letting both users and SysAdmin log in from the same authentication window. The properties are all saved in a PostgreSQL database on my machine here. I have created a user who has insert, update, select and delete priveleges on all tables in my database. This user is unable to create databases or users. When the SysAdmin logs in he will have a page where he can modify houses etc, while when an ordinary user logs in he will have the basic window where he can search for houses. At the moment I have it such that both users and SysAdmin when connected are connected as webadmin. I dont think this is a very secure method but its all i can think of at the moment. I'm also not sure how to kep the SysAdmin's page secure from everybody else. At the moment all my pages are in a /usr/local/apache/htdocs/project/ directory. Does anybody have an idea how i could make this implementation more secure and functional. Thanks, Paul