Ok. Someone else was talking about this earlier in the list, but I didn't see the answer that I am looking for. I have just setup a new RedHat 9.0 server with MySQL 3.23.58. My program that worked on an older version of MySQL doesn't work on this one. The problem is that the temporary tables are not being created. How can I turn on the GRANT function so that each of the users that have databases can create temporary tables in their own databases ONLY. Can this be done with a GLOBAL type of grant? If so, what would be the Grant statement to turn this on? Or will I have to define this each time a user us setup? If so, what would be the Grant statement to turn this on this way?
The docs did show a little about this, but not this specifically (that I found) and since I am new to this type of grant, I don't want to screw things up.


Thanks
Steve


-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to