Greetings, Ryan Johnson! > On 22/12/2012 7:36 AM, Andrey Repin wrote: >> Greetings, Ryan Johnson! >> >>> I'm trying to set up pgsql for classroom instruction, which means I need >>> to allow students to connect to my machine, preferably with no OS-level >>> privileges and minimal database privileges. >> If your class is about setting up the server, you should really use virtual >> machines. >> If it's about using SQL on already running server, it makes no difference, if >> you've your server as Cygwin port or native application - clients will never >> know. >> >>> Setting up the database roles looks straightforward enough, but I'm having >>> trouble figuring out how to secure the machine. >> It is unclear to me, why you need to let students access the machine. > Most student work will be done on private installs of pgsql, which they > can set up however they'd like.
> However, we're going to do classroom demos at times, including one where > we have fun with different isolation levels; I'll need multiple students > logged into the same database so they can mess with each others' > interactive transactions. The answer remains the same - use virtual machines. Probably, with Linux. Then you would be able to have pre-made system installations for every class, and what more important, you could easily restore each VM to the state you want it in for a next group of students taking the same class. -- WBR, Andrey Repin (anrdae...@freemail.ru) 23.12.2012, <05:51> Sorry for my terrible english... -- Problem reports: http://cygwin.com/problems.html FAQ: http://cygwin.com/faq/ Documentation: http://cygwin.com/docs.html Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple