Jim, I'd like to help, but I dont answer questions directly. Please post your question to the mysql mailing list in future. I have crossposted this to the list.
kind regards, Mark Maunder. Jim Chivas wrote: > Mark: > > I work in a School where the teachers want to use mysql. > > A while back you referred me to thge web page on > www.mysql.com/doc/U/s/user_Account_Management.html as a reference for the > following questions: > > Some were answered but some were not. Could you supply the syntax to do > the following: > > 1. Once I have created a Teacher what is the 'grant syntax to allow this > Teacher to create/modify their new databases/tables but not to by default > use any other tables. > > 2. Once I have setup their students, what grant syntax would I use to > allow the students to add/modify but NOT delete the database? > > 2. Once the school year is over how do I remove any databases these > Teachers have created? > > 3. WHere are these mysql databases stored? IN the users $HOME area or ?? > > Any help would be appreciated. > > Thanks > > Jim > > -- --------------------------------------------------------------------- > > Jim Chivas email: [EMAIL PROTECTED] > Information And Computing services fax: (604) 323-5349 > Langara College Voice: (604) 323-5390 > 100 West 49th Avenue http://www.langara.bc.ca > Vancouver, B.C., Canada > V5Y 2Z6 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
