Fajar Priyanto <[EMAIL PROTECTED]> wrote:
> Hi all,
> Can I create a user that can create and drop his database while at the same=
> time can not drop databases that are not belong to him?
> How do I set this priviledge?
If you grant CREATE and DROP privileges on the dbname, it means that user can only
create and drop database with name 'dbname'.
GRANT CREATE, DROP ON dbname.* TO 'user'@'hostname' IDENTIFIED BY 'userpassword';
http://dev.mysql.com/doc/mysql/en/Privileges_provided.html
http://dev.mysql.com/doc/mysql/en/GRANT.html
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ [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]
