Thanks Steve
At 08:07 AM 10/28/2003, you wrote:
Hi there,
I guess you are going to have to grant this at the database level, unfortunately for you. These privileges are stored in the mysql.db and mysql.host tables, or can be manipulated using something like the following, which is a little easier to try out:
GRANT CREATE TEMPORARY TABLES ON my_db.* TO 'user' IDENTIFIED BY 'pass';
I'm doing this and it works fine :) I guess if you have multiple databases and users you could make a INSERT INTO ... SELECT statement to manipulate the mysql tables directly and then do a flush priveledges.
Hope that helps,
Mike
> -----Original Message----- > From: Steve Buehler [mailto:[EMAIL PROTECTED] > Sent: 28 October 2003 13:51 > To: mysql > Subject: GRANT CREATE TEMPORARY TABLES > > > 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] > > > >
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
