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
_/ IT Delivery Specialist - Database
_/ Hewlett-Packard Australia Ltd
_/_/_/ _/_/_/ E-Mail: david.logan (AT) hp (DOT) com
_/ _/ _/ _/ Desk: +618 8408 4273
_/ _/ _/_/_/ Mobile: 0417 268 665
_/
_/ Postal: 148 Frome Street,
_/ Adelaide SA 5001
Australia
i n v e n t

hi

Hope there is no privilege type of REPAIR [Repair Table] supported by MySQL Server.

use
>SHW PRIVILEGES;
SHW 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, PRCESS, RELAD, REPLICATIN CLIENT, REPLICATIN SLAVE, SHW DATABASES, SHUTDWN, and SUPER privileges are administrative privileges that can only be granted globally . SELECT, INSERT, UPDATE, (both table and column level privileges),DELETE, CREATE, DRP, GRANT PTIN, INDEX, ALTER, CREATE VIEW and SHW VIEW are Table level privileges and ALTER RUTINE, EXECUTE, and GRANT PTIN are Routine specific privileges. CREATE RUTINE is not a routine-level privilege because you must have this privilege to create a routine in the first place.

Thanks

Visolve DB Team.

Message
From: "Logan, David (SST - Adelaide)" <David.Logan (AT) hp (DOT) com>
To: "MySQL List" <mysql (AT) lists (DOT) 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
_/ IT Delivery Specialist - Database
_/ Hewlett-Packard Australia Ltd
_/_/_/ _/_/_/ E-Mail: david.logan (AT) hp (DOT) com
_/ _/ _/ _/ Desk: +618 8408 4273
_/ _/ _/_/_/ Mobile: 0417 268 665
_/
_/ Postal: 148 Frome Street,
_/ Adelaide SA 5001
Australia
i n v e n t