-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Thanks Egor, It works. But it seems that it's not 100% automatically just like unix file permission. The administrator must set it up on each database. So, I give the users CREATE privilege globally, but not DROP. It will prevent them from messing around with others that are not theirs.
On Wednesday 05 May 2004 03:26 pm, Egor Egorov wrote: > 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 - -- Fajar Priyanto | Reg'd Linux User #327841 | http://linux.arinet.org 16:56:48 up 8:52, Mandrake Linux release 9.2 (FiveStar) for i586 public key: https://www.arinet.org/fajar-pub.key -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.3 (GNU/Linux) iD8DBQFAmLrkkp5CsIXuxqURArGsAJ9EXtAkkQ4ljdpyMMoU3rVam/iSlwCfbEIs WVJxZ/nvO8agp6jwj1KNq8g= =2pYJ -----END PGP SIGNATURE----- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]