List:General Discussion« Previous MessageNext Message »
From:Gleb Paharenko Date:August 10 2005 10:50pm
Subject:Re: GRANTS for tables - why is "create" possible?
View as plain text  
Hello.

In my opinion, it means that user `root`@`%`
is able to create table address in your current
database (SHOW GRANTS shows that the name of the
database is implicitly added to the table name).


"Martijn Tonies" <m.tonies@stripped> wrote:
> 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
> 
> 


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   Gleb.Paharenko@stripped
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
       <___/   www.mysql.com



Thread
GRANTS for tables - why is "create" possible?Martijn Tonies9 Aug
  • Re: GRANTS for tables - why is "create" possible?Gleb Paharenko11 Aug