>Description:
Under 4.0.0, the LOCK TABLES command requires the following global privileges:
SELECT, INSERT, DELETE, UPDATE. This is not true under 3.23. Is this done
for a reason, or is it a bug?
>How-To-Repeat:
Use the SQL "LOCK TABLES" command as a non-privileged user under MySQL 4.0.0.
>Fix:
>Submitter-Id: <submitter ID>
>Originator: Michael McClennen
>Organization: Internet Public Library, University of Michigan
>
>Synopsis: The LOCK TABLES command now requires global privileges
>Severity: serious
>Priority: high
>Category: mysql
>Class: sw-bug
>Release: mysql-4.0.0-alpha (Official MySQL binary)
>Environment:
System: SunOS thales.si.umich.edu 5.8 Generic_108528-06 sun4u sparc SUNW,UltraAX-i2
Architecture: sun4
Some paths: /usr/local/bin/perl /usr/si/bin/make /usr/um/gnu/bin/gmake
/usr/si/bin/gcc /usr/si/bin/cc
GCC: Reading specs from
/usr/si/gcc-2.95.3/lib/gcc-lib/sparc-sun-solaris2.8/2.95.3/specs
gcc version 2.95.3 20010315 (release)
Compilation info: CC='gcc' CFLAGS='-O3 -fno-omit-frame-pointer' CXX='gcc'
CXXFLAGS='-O3 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti'
LDFLAGS=''
LIBC:
-rw-r--r-- 1 root bin 1754016 Nov 23 2000 /lib/libc.a
lrwxrwxrwx 1 root root 11 Mar 30 2001 /lib/libc.so -> ./libc.so.1
-rwxr-xr-x 1 root bin 1129948 Nov 23 2000 /lib/libc.so.1
-rw-r--r-- 1 root bin 1754016 Nov 23 2000 /usr/lib/libc.a
lrwxrwxrwx 1 root root 11 Mar 30 2001 /usr/lib/libc.so -> ./libc.so.1
-rwxr-xr-x 1 root bin 1129948 Nov 23 2000 /usr/lib/libc.so.1
Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official
MySQL binary' --with-extra-charsets=complex --with-server-suffix=
--enable-thread-safe-client --enable-assembler --disable-shared
---------------------------------------------------------------------
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
