Ed Brown <[EMAIL PROTECTED]> wrote: > To restate an earlier question more concisely: > > Is it true that a user who is given all privileges, including grant > option, on a database (e.g., in order to administer that database) can > create other users with any or all of his privileges, but cannot give > them passwords?
Yes. > Is there some way to create an admin for a specific > database that can do this, short of giving her update_priv on > mysql.user.password(definitely not an option)? Is the only alternative > that a root or other super-user assign initial passwords? Or user can set password by himself. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [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]
