Global CREATE command also needed to create temporary tables.
am 19.08.2002 17:22:30 von Melvyn Sopacua>Description:
In addition to the fact, that a global grant for create temporary tables is
needed, one also needs to grant a global CREATE privilege, otherwise,
even with full privileges on the database, the 'create command is denied'.
>How-To-Repeat:
Will be uploaded as it requires user switches.
>Fix:
Unknown.
>Submitter-Id:
>Originator: Melvyn Sopacua
>Organization:
IDG.nl
>MySQL support: none
>Synopsis: Global CREATE command also needed to create temporary tables.
>Severity: serious
>Priority: medium
>Category: mysql
>Class: sw-bug
>Release: mysql-4.0.2-alpha (AIX 4.3.3 statically linked)
>Server: /data/mdev/mysql/bin/mysqladmin Ver 8.35 Distrib 4.0.2-alpha, for ibm-aix4.3.3.0 on rs6000
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.2-alpha-log
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /data/mdev/sql/tmp/mysql4.sock
Uptime: 5 hours 24 min 22 sec
Threads: 12 Questions: 189339 Slow queries: 4 Opens: 707 Flush tables: 1 Open tables: 64 Queries per second avg: 9.729
>Environment:
System: AIX femke 3 4 0044CA0A4C00
Some paths: /bin/perl /bin/make /home/mdev/local/bin/gmake /usr/local/bin/gcc /home/mdev/bin/cc
GCC: Reading specs from /usr/local/lib/gcc-lib/powerpc-ibm-aix4.3.2.0/2.95.2.1/specs
gcc version 2.95.2.1 19991024 (release)
Compilation info: CC='gcc -pipe -mcpu=power -Wa,-many' CFLAGS='' CXX='gcc -pipe -mcpu=power -Wa,-many' CXXFLAGS='-felide-constructors -fno-exceptions -fno-rtti' LDFLAGS=''
LIBC:
lrwxrwxrwx 1 bin bin 19 May 14 2001 /lib/libc.a -> /usr/ccs/lib/libc.a
lrwxrwxrwx 1 bin bin 19 May 14 2001 /usr/lib/libc.a -> /usr/ccs/lib/libc.a
Configure command: ./configure --prefix=/data/mdev/mysql --localstatedir=/data/mdev/sql/var --disable-shared --with-raid --with-unix-socket-path=/data/mdev/sql/tmp/mysql.sock --with-mysqld-user=mdev --with-mysqld-ldflags=-Wl,-bbigtoc --without-debug '--with-comment=AIX 4.3.3 statically linked' --without-bench --with-charset=latin1 --with-extra-charsets=none --without-isam --with-berkeley-db 'CC=gcc -pipe -mcpu=power -Wa,-many' 'CXXFLAGS=-felide-constructors -fno-exceptions -fno-rtti' 'CXX=gcc -pipe -mcpu=power -Wa,-many'
------------------------------------------------------------ ---------
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-thread12373@lists.mysql.com
To unsubscribe, e-mail