>Description:
After upgrading from 3.23 to 4.0 and running mysql_fix_privilege_tables,
GRANT SELECT on *.* to a replication slave user seems to also grant the
WITH GRANT OPTION privilege. (SELECT is needed for LOAD DATA FROM MASTER).
>How-To-Repeat:
mysql> show grants for 'replicant'@'great5.greatschools.net' \G
*************************** 1. row ***************************
Grants for [EMAIL PROTECTED]: GRANT RELOAD, PROCESS, FILE, SHOW DATABASES, SUPER,
CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT
ON *.* TO 'replicant'@'great5.greatschools.net'
1 row in set (0.00 sec)
mysql> grant select on *.* to 'replicant'@'great5.greatschools.net'
-> ;
Query OK, 0 rows affected (0.00 sec)
mysql> show grants for 'replicant'@'great5.greatschools.net' \G
*************************** 1. row ***************************
Grants for [EMAIL PROTECTED]: GRANT SELECT, RELOAD, PROCESS, FILE, SUPER, CREATE
TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT ON *.*
TO 'replicant'@'great5.greatschools.net' WITH GRANT OPTION
1 row in set (0.00 sec)
>Fix:
unknown
>Submitter-Id: <submitter ID>
>Originator: John David Duncan
>Organization: GreatSchools.Net
>MySQL support: email support
>Synopsis: GRANT SELECT can give GRANT OPTION privilege
>Severity: non-critical
>Priority: low
>Category: mysql
>Class: sw-bug
>Release: mysql-4.0.14 (yes)
>C compiler: 2.95.3
>C++ compiler: 2.95.3
>Environment:
System: FreeBSD great6 4.6-RELEASE FreeBSD 4.6-RELEASE #0: Sun Jun 16 18:00:48 PDT
2002 [EMAIL PROTECTED]:/usr/obj/usr/src/sys/GREAT i386
Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Using builtin specs.
gcc version 2.95.3 20010315 (release) [FreeBSD]
Compilation info: CC='gcc' CFLAGS='-O3 -march=pentiumpro' CXX='gcc' CXXFLAGS='-O3
-march=pentiumpro -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS=''
ASFLAGS=''
LIBC:
-r--r--r-- 1 root wheel 1222232 Jun 17 2002 /usr/lib/libc.a
lrwxr-xr-x 1 root wheel 9 Jun 17 2002 /usr/lib/libc.so -> libc.so.4
-r--r--r-- 1 root wheel 579412 Jun 17 2002 /usr/lib/libc.so.4
Configure command: ./configure '--with-mysqld-user=mysql' '--enable-assembler'
'--with-comment' '--localstatedir=/var/mysql' '--disable-shared'
'--with-mysqld-ldflags=-all-static' '--with-gnu-ld' '--with-charset=latin1'
'--with-extra-charsets=complex' 'CFLAGS=-O3 -march=pentiumpro' 'CXXFLAGS=-O3
-march=pentiumpro -felide-constructors -fno-exceptions -fno-rtti' 'CXX=gcc'
Perl: This is perl, version 5.005_03 built for i386-freebsd
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
