sql,query
>>>HI sorry for the confusion. >>>well...... I want to create a database where I can give *any* name >>>(ofcourse, the database doesn't exist). >>> >>>Are you trying to say, I need to ask the root, to give me create >>>privilege on database "xxx", even before it exist, then only I can >>>create the database "xxx". Then every time when I want to create a >>>new database, I need to ask the root to give create privilege ??? >> >> >>Well, yes, you need to have privileges on a database to be able to create >>it. However, if you have the global CREATE privilege, you can create *any* >>database. So maybe that's what you want. The GRANT statement for >>this will look like: >> >>GRANT CREATE ON *.* TO ddb@localhost IDENTIFIED BY 'passwd'; >> >>*.* as a level specifier means "global". >> >>Is that what you want? > > >Yes....! here I go again!! >If I get the global CREATE, yes I can create any databases, but also >it will allows me to create tables under any database?? isn't that >right?? Right. CREATE applies both to databases and to tables. There are not separate create-database and create-table privileges. >Is it possible, i can create new databases (with any name) but I >will not have any access to other existing database?? >Thanks No. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php