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!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. 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...
  2. toucaninc

    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.
  3. toucaninc

    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...

Part and Inventory Search

Back
Top