473,388 Members | 868 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,388 software developers and data experts.

Grant "optimize" difference in 4.0.14 and 4.0.16 ?

Hi,

I ran the code below on two different versions, 4.0.14 and 4.0.16
respectively, both running RH 7.3 on intel.

In version mysql server version 4.0.14 the SELECT privelege suffices
for "optimize table", but (seemingly) the server version 4.0.16
requires INSERT as well.

Is the INSERT privelege necessary for performing optimize in mysql
server version >= 4.0.16 ? I haven't found anything on this in the
changelogs, but I guess I might have missed something.

################################################## ##########################

Server 1:

mysql> select version();
+------------+
| version() |
+------------+
| 4.0.14-Max |
+------------+
1 row in set (0.03 sec)

mysql> GRANT SELECT ON mydb.tq TO tqoptimizer@localhost IDENTIFIED BY
'XXX';
Query OK, 0 rows affected (0.00 sec)

mysql> exit
Bye
[16:05:ro**@4.0.14-server] $ /usr/bin/mysql -u tqoptimizer
--password=XXX -e 'optimize table tq' mydb
+-----------+----------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+-----------+----------+----------+----------+
| mydb.tq | optimize | status | OK |
+-----------+----------+----------+----------+

################################################## ##########################

Server 2:

mysql> select version();
+----------------+
| version() |
+----------------+
| 4.0.16-Max-log |
+----------------+
1 row in set (0.00 sec)

mysql> GRANT SELECT ON mydb.tq TO tqoptimizer@localhost IDENTIFIED BY
'XXX';
Query OK, 0 rows affected (0.00 sec)

mysql> exit;
Bye
[16:09:ro**@4.0.16-server:] $ /usr/bin/mysql -u tqoptimizer
--password=XXX -e 'optimize table tq' mydb
ERROR 1142 at line 1: insert command denied to user:
'tqoptimizer@localhost' for table 'tq'

################################################## ##########################

--
Andreas
Jul 20 '05 #1
0 1768

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: f.ruecker | last post by:
Hey Folks, I hope you'll be nice to me and let this post go through even know its mysql and not directly php. But of course my script is php. The problem is, that my Table (1,8 MIO entries/100...
3
by: Paul Janssen | last post by:
Hello! Can anyone help me out with the following situation: (a) a single query with 550 id's in the IN-clause resulting into 800+ seconds; (b) 550 queries with a single id in the IN-clause...
145
by: Sidney Cadot | last post by:
Hi all, In a discussion with Tak-Shing Chan the question came up whether the as-if rule can cover I/O functions. Basically, he maintains it can, and I think it doesn't. Consider two...
6
by: Charlie | last post by:
Hi: Is there any difference between string.Empty and String.Empty? And what is the benefit of using it over "". Thanks, Charlie
0
by: mmiller | last post by:
Does anyone know of a Add-In for VS.NET 2005 that optimizes the using statements in a code file like Resharper does (basically order them, remove un-need ones, etc.). Resharper for VS.NET 2005 is...
14
by: mlw | last post by:
Do not take anything about this, it is not a flame or troll, while I'm not new to Java I favor C++. However, I may need to use it in a contract position, and am concerned that the restrictions it...
94
by: Samuel R. Neff | last post by:
When is it appropriate to use "volatile" keyword? The docs simply state: " The volatile modifier is usually used for a field that is accessed by multiple threads without using the lock...
17
by: Martin Wells | last post by:
When passing arguments to a VAL function, all integer types are promoted, and floats become doubles. Therefore, signed short will be promoted to signed int. Therefore I can't see any reason why...
350
by: Lloyd Bonafide | last post by:
I followed a link to James Kanze's web site in another thread and was surprised to read this comment by a link to a GC: "I can't imagine writing C++ without it" How many of you c.l.c++'ers use...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.