>Description:
FLUSH TABLE <name> requires a global RELOAD privilege, even
though it only operates on a table in a given database. RELOAD privileges
cannot be granted on specific databases or even tables.
>How-To-Repeat:
mysql> grant reload on test.* to [EMAIL PROTECTED];
ERROR 1221 (HY000): Wrong usage of DB GRANT and GLOBAL PRIVILEGES
mysql> grant reload on test.T to [EMAIL PROTECTED];
ERROR 1144 (42000): Illegal GRANT/REVOKE command. Please consult the manual which
privileges can be used
>Fix:
Current work around is to GRANT RELOAD ON *.*, but this isn't very satisfying.
>Submitter-Id: <submitter ID>
>Originator: Lukas Knecht
>Organization:
EraGen Biosciences Inc.
>MySQL support: licence
>Synopsis: RELOAD privilege is global, but FLUSH TABLE is local.
>Severity: non-critical
>Priority: medium
>Category: mysql
>Class: change-request
>Release: mysql-4.1.1-alpha-max (Official MySQL-max binary)
>C compiler: 2.95.3
>C++ compiler: 2.95.3
>Environment:
System: Linux barks 2.4.18-4GB #1 Tue Dec 2 18:01:08 GMT 2003 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/i486-suse-linux/2.95.3/specs
gcc version 2.95.3 20010315 (SuSE)
Compilation info: CC='gcc' CFLAGS='-O2 -mpentiumpro -DBIG_TABLES' CXX='gcc'
CXXFLAGS='-O2 -mpentiumpro -felide-constructors -DBIG_TABLES' LDFLAGS='' ASFLAGS=''
LIBC:
-rwxr-xr-x 1 root root 1394302 Mar 27 2003 /lib/libc.so.6
-rw-r--r-- 1 root root 25362104 Mar 27 2003 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Mar 23 2002 /usr/lib/libc.so
Configure command: ./configure '--prefix=/usr/local/mysql'
'--localstatedir=/usr/local/mysql/data' '--libexecdir=/usr/local/mysql/bin'
'--with-comment=Official MySQL-max binary' '--with-extra-charsets=complex'
'--with-server-suffix=-max' '--enable-thread-safe-client' '--enable-local-infile'
'--enable-assembler' '--disable-shared' '--with-berkeley-db' '--with-raid'
'--with-readline' '--with-embedded-server' '--with-innodb' 'CFLAGS=-O2 -mpentiumpro
-DBIG_TABLES' 'CXXFLAGS=-O2 -mpentiumpro -felide-constructors -DBIG_TABLES' 'CXX=gcc'
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
