--- Amer Neely <[EMAIL PROTECTED]> wrote: > > Greetings all. Hope someone could give me some pointers on this. > > > > I am working at a small ISP in Montreal. Some of our corpo users. have > > access to a MySQL database, that we created for them (usually, this DB is > > named after there username). The way we configured our mysql installation, > > which seams a pretty standard procedure, they can create as many tables as > > they want in there DB, but of course, they can't another DB. > > > > Well, we would like to do just that. > > > > Is there a way to configure mysql so that the user can create as much DB as > > he wants, by making sure every DB created by this user can only be accessed > > by him, some kind of 'root' access if you follow my logic. Furthermore, > > since we are billing our clients for the disk space they are using, will > the > > structure of this will ressemble to this ; > > > > MAIN_USER - DB1 - table1, table2, ... > > - DB2 - table1, table2, ... > > > > Thanks for any help.
I asked the same question a little while ago and the answer given to me was this: mysql> GRANT ALTER,CREATE,DELETE,DROP,INDEX,SELECT,UPDATE ON `user%`.* TO 'user'@'%' IDENTIFIED BY "password"; Of course you GRANT the user whatever privs you wantt hem to have, I think the only one they NEED to have is CREATE and then "user" will get to create any DB as long as it starts with their username, like userDB2. And please if anyone sees that I have messed up any thing in this please correct me. HTH, Ryan __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com --------------------------------------------------------------------- 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
