hi
Hope there is no privilege type of REPAIR [Repair Table] supported by MySQL
Server.
use
>SHOW PRIVILEGES;
SHOW PRIVILEGES shows the list of system privileges that the MySQL server
supports. The exact list of privileges depends on the version of your server.
For the global, database, table, and routine levels, GRANT ALL assigns only the
privileges that exist at the level you are granting.
The FILE, PROCESS, RELOAD, REPLICATION CLIENT, REPLICATION SLAVE, SHOW
DATABASES, SHUTDOWN, and SUPER privileges are administrative privileges that
can only be granted globally . SELECT, INSERT, UPDATE, (both table and column
level privileges),DELETE, CREATE, DROP, GRANT OPTION, INDEX, ALTER, CREATE VIEW
and SHOW VIEW are Table level privileges and ALTER ROUTINE, EXECUTE, and GRANT
OPTION are Routine specific privileges. CREATE ROUTINE is not a routine-level
privilege because you must have this privilege to create a routine in the first
place.
Thanks
Visolve DB Team.
----- Original Message -----
From: "Logan, David (SST - Adelaide)" <[EMAIL PROTECTED]>
To: "MySQL List" <mysql@lists.mysql.com>
Sent: Thursday, August 24, 2006 7:18 AM
Subject: REPAIR TABLE and mysqlcheck
Hi Folks,
Does anybody know if it is possible to restrict access to these commands
on an individual basis? I have a need to exclude users, who would
otherwise have most privileges, and was wondering if there was a
particular privilege that I could revoke.
If not, does anybody have a technique that may provide for this?
Thanks
---------------------------------------------------------------
********** _/ ********** David Logan
******* _/ ******* ITO Delivery Specialist - Database
***** _/ ***** Hewlett-Packard Australia Ltd
**** _/_/_/ _/_/_/ **** E-Mail: [EMAIL PROTECTED]
**** _/ _/ _/ _/ **** Desk: +618 8408 4273
**** _/ _/ _/_/_/ **** Mobile: 0417 268 665
***** _/ ******
****** _/ ******** Postal: 148 Frome Street,
******** _/ ********** Adelaide SA 5001
Australia
i n v e n t
---------------------------------------------------------------
