I am looking to allow access to a class of students to a database. However, I would like to be the owner of all table they create w/o having to take control of them later. I would also like to allo/deny access via a simple database query. I have decided to write a script that accesses the database with my username/pass hardcoded in it such that they can type
\ myscript "sql statement"
and it would execute the sql statement and return the results to stdout. I would also like to record the username and statement executed in a logfile