From: Martijn Tonies
Date: August 9 2005 2:20pm
Subject: GRANTS for tables - why is "create" possible?
List-Archive: http://lists.mysql.com/mysql/187553
Message-Id: <02be01c59ced$8572c280$3802a8c0@martijnws>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Hi there,

What is the purpose of this GRANT statement?

GRANT CREATE ON <tablename> TO `root`@`%`;

eg:
GRANT CREATE ON address TO `root`@`%`;

It's possible, but what is it supposed to do?

I can understand this grant on a global (server) and database
level, but on a table level?

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com