Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by toucaninc
-
Temporary tables, select privilege problem
Yes, I can reproduce the error in the console, and in my java program. If I give my user abc the Select privilege to the whole database, I don't get the error. But I cannot do that for security issues, there are some tables in my database that abc must not have access. Of course, I could give... -
Temporary tables, select privilege problem
I think I run version MySQL-server-4.1.0-0 (that's what I get when I run rpm -q MySQL-server). I also ran mysql_fix_privilege_tables script. And yes, the user abc has Create_tmp_table_priv='Y'. He can create the table, but cannot do a Select query on it. -
Temporary tables, select privilege problem
Hi. SITUATION: -I have a user named "abc", he is not a root, he cannot grant privileges. -I have a database named "Toucan". -I have a table in this database named "Cookies" -The user doesn't have SELECT privilege on the database, but has some SELECT privileges...
