[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql-bugs
Subject:    BUG report (CREATE TEMPORARY TABLES problem) 4.0.2/4.0.3-bk snapshot
From:       "Sergey S. Kostyliov" <rathamahata () php4 ! ru>
Date:       2002-07-30 12:03:30
[Download RAW message or body]

>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 version	10
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 20000731 (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: 
lrwxrwxrwx    1 root     root           13 éÀÌ  8 20:18 /lib/libc.so.6 -> 
libc-2.2.5.so
-rwxr-xr-x    1 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
lrwxrwxrwx    1 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 bugs-thread12241@lists.mysql.com
To unsubscribe, e-mail <bugs-unsubscribe@lists.mysql.com>

[prev in list] [next in list] [prev in thread] [next in thread]