On Friday 11 June 2004 06:59 pm, Robert Paulsen wrote: > I must be missing something about "create temporary table". Here are two > sql commands. The first works the second fails: > > CREATE TABLE mytable (id int(10) NOT NULL auto_increment, data > varchar(255), PRIMARY KEY (id) ); CREATE TEMPORARY TABLE mytable2 (id > int(10) NOT NULL auto_increment, data varchar(255), PRIMARY KEY (id) ); > > Prior to issuing the above commands I used the following grant command: > > GRANT ALL ON MYDB.* TO [EMAIL PROTECTED] identified by 'password' > > I also tried the following: > > GRANT CREATE TEMPORARY TABLE ON MYDB.* TO [EMAIL PROTECTED] identified by > 'password' > > but it didn't help. > > What am I missing? >
Well, I haven't done an exhaustive analysis, but I *think* there is a mysql bug (I'm at 4.0.18). The GRANT statement is not supposed to require a FLUSH PRIVILEGES and this seems to be true for the CREATE TABLE privilege but not for the CREATE TEMPORARY TABLE privilege. I say this because my problem went away when I used mysqladmin to "flush-privileges". -- Robert C. Paulsen, Jr. [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
