Re: BUG report (CREATE TEMPORARY TABLES problem) 4.0.2/4.0.3-bk snapshot
Sergey S. Kostyliov writes: Description: Any grant at a tables level make 'CREATE TEMPORARY TABLE' privilege not working ERROR 1142 How-To-Repeat: 1) (under root) mysql GRANT CREATE TEMPORARY TABLES ON *.* TO test_user@localhost IDENTIFIED BY 'test_pass'; Query OK, 0 rows affected (0.01 sec) 2) (under test_user) mysql CREATE TEMPORARY TABLE tmp_table(i INT); Query OK, 0 rows affected (0.00 sec) 3) (under root) mysql CREATE TABLE t (i INT); Query OK, 0 rows affected (0.00 sec) mysql GRANT SELECT ON test.t TO test_user@localhost; Query OK, 0 rows affected (0.00 sec) 4) (under test_user) mysql CREATE TEMPORARY TABLE tmp_table(i INT); ERROR 1142: create command denied to user: 'test_user@localhost' for table 'tmp_table' Hi! Thank you for your bug report. Thanks to it, the above bug was fixed and fix will come up in 4.0.3. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
BUG report (CREATE TEMPORARY TABLES problem) 4.0.2/4.0.3-bk snapshot
Description: Any grant at a tables level make 'CREATE TEMPORARY TABLE' privilege not working ERROR 1142 How-To-Repeat: 1) (under root) mysql GRANT CREATE TEMPORARY TABLES ON *.* TO test_user@localhost IDENTIFIED BY 'test_pass'; Query OK, 0 rows affected (0.01 sec) 2) (under test_user) mysql CREATE TEMPORARY TABLE tmp_table(i INT); Query OK, 0 rows affected (0.00 sec) 3) (under root) mysql CREATE TABLE t (i INT); Query OK, 0 rows affected (0.00 sec) mysql GRANT SELECT ON test.t TO test_user@localhost; Query OK, 0 rows affected (0.00 sec) 4) (under test_user) mysql CREATE TEMPORARY TABLE tmp_table(i INT); ERROR 1142: create command denied to user: 'test_user@localhost' for table 'tmp_table' Fix: mysql DELETE FROM mysql.tables_priv; mysqadmin relad Submitter-Id: Originator:Sergey S. Kostyliov Organization: eHouse (http://www.ehouse.ru) MySQL support: none Synopsis: 'CREATE TEMPORARY TABLE' privilege broken by any per-tables grant Severity: serious Priority: medium Category: mysql Class: sw-bug Release: mysql-4.0.3-alpha (Source distribution) Server: /usr/bin/mysqladmin Ver 8.35 Distrib 4.0.3-alpha, for pc-linux-gnu on i686 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 4.0.3-alpha-log Protocol version10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock Uptime: 22 hours 39 min 52 sec Threads: 2 Questions: 6558765 Slow queries: 0 Opens: 481 Flush tables: 1 Open tables: 234 Queries per second avg: 80.385 Environment: System: Linux white.unishop.org.ru 2.4.19-rc3aa3 #1 SMP ðÎÄ éÀÌ 29 12:01:56 MSD 2002 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.3 2.96-110) Compilation info: CC='/usr/local/gcc-3.1/bin/gcc' CFLAGS='-O4 -march=pentium3 -mcpu=pentium3 -msse -pipe' CXX='/usr/local/gcc-3.1/bin/gcc' CXXFLAGS='-O4 -march=pentium3 -mcpu=pentium3 -msse -pipe -felide-constructors -fno-exceptions -fno-rtti -DUSE_MYSYS_NEW' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 éÀÌ 8 20:18 /lib/libc.so.6 - libc-2.2.5.so -rwxr-xr-x1 root root 1260480 éÀÎ 18 18:45 /lib/libc-2.2.5.so -rw-r--r--1 root root 2312370 éÀÎ 18 18:13 /usr/lib/libc.a -rw-r--r--1 root root 178 éÀÎ 18 17:58 /usr/lib/libc.so lrwxrwxrwx1 root root 10 éÀÌ 8 23:35 /usr/lib/libc-client.a - c-client.a Configure command: ./configure --prefix=/usr --libexecdir=/usr/sbin --localstatedir=/var/lib/mysql --mandir=/usr/share/man --infodir=/usr/share/info --enable-assembler --with-mysqld-ldflags=-all-static --with-mysql-user=mysql --with-innodb --with-unix-socket-path=/var/lib/mysql/mysql.sock --with-extra-charsets=latin1,koi8_ru,cp1251 --enable-thread-safe-client - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php