Hello.
In my opinion, it means that user [EMAIL PROTECTED] 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" <[EMAIL PROTECTED]> wrote: > Hi there, > > What is the purpose of this GRANT statement? > > GRANT CREATE ON <tablename> TO [EMAIL PROTECTED]; > > eg: > GRANT CREATE ON address TO [EMAIL PROTECTED]; > > 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 / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]