<FONT face="Default Sans Serif,Verdana,Arial,Helvetica,sans-serif" size=2><div><font size="3">Using </font><font size="3">Postgresql 8.2.11 on Ubuntu 7.10.<br><br></font><font size="3">I am writing a J2EE project but do not want user specific schemas because this application sits on a production floor and any production employee can walk to a workstation and access the database to punch work time. I know that the public schema is not supposed to be used. <br><br>Is the best practice to make one schema for the database and then delete public? <br><br>Will using a schema other than public cause problems for users accessing the database with ODBC from Windows?<br><br>Thank you,</font><font size="3"> <br>Margaret.<br></font></div></FONT>