Re: GRANTS for tables - why is "create" possible?

2005-08-11 Thread Gleb Paharenko
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

GRANTS for tables - why is "create" possible?

2005-08-09 Thread Martijn Tonies
Hi there, What is the purpose of this GRANT statement? GRANT CREATE ON 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