MySQL Security permissions

Question

Is it possible in MySQL to block users from executing these statements?

DESC "table"
SHOW TABLES
SHOW CREATE TABLE "table"

Or I need to write a MySQL transport port wrapper ?

GRANT ON TABLE does not help to hide database structure from a user.
I want my developers to not be allowed of dumping database structure and show tables name

The configuration file: /etc/my.cnf

[mysqld]
skip-show-database
skip-networking
bind-address=127.0.0.1
#skip-show-tables
#skip-table-stucture-show

Answer 1

What I am about to say would be rather crazy but entirely possible. Here it goes...

CRAZY SUGGESTION #1

• Download the source code for the mysql client
• Remove the commands
  • DESC "table"
  • SHOW TABLES
  • SHOW CREATE TABLE "table"
• Compile the source
• Give your developers access to this special compiled version of the mysql client

CRAZY SUGGESTION #2

• Download MySQL Proxy
• Program the LUA scripts to ignore
  • DESC "table"
  • SHOW TABLES
  • SHOW CREATE TABLE "table"
• Have your developers access DB using MySQL-Proxy-based IP Addresses

EPILOGUE

I would say Give it a Try, but I have never done anything like this before.

Notwithstanding, it would be a brave C/C++ or LUA soul indeed to engage in such an undertaking...

Answer 2

SHOW TABLE is implied by SELECT because SELECT means you need to see the table structure. So it can't be blocked. The same applies for SHOW CREATE TABLE

DESC = DESCRIBE = SHOW COLUMNS FROM anyway, which is the same.

So no, it can't be done via MySQL Permissions if you want the developers to run queries