Hi!
On May 20, Jeremy Cole wrote:
>
>> To distinguish roles from users I propose to use "Host" field of
>> mysql.user table - If this field is empty then we should consider the
>> specified record to be a role.
>
> I see all the discussion around this, but I would propose a different
> tack: why not use a host which would otherwise be reserved? The
> similarity in functionality and such between users and roles is
> obvious, but you don't want to break or change existing functionality.
> How about e.g. role "foo" would be equivalent to user "foo" @ "$role".
> Since $ (or @, #, &, ^, *, !, etc.) would never appear in a
> well-formed hostname or IP address, they call all be used to mark a
> role as such. The commands to deal with roles would then really just
> be aliases on user@"$role" and thus very easy to implement.
This is a cool idea. It nicely solves the problem of the empty hostname
in the mysql.db table and provides a far better visual indicator than an
empty hostname that a row in 'SELECT * FROM mysql.user' coresponds to a
role.
Thanks, Jeremy!
Regards / Mit vielen Grüssen,
Sergei
--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <serg@stripped>
/ /|_/ / // /\ \/ /_/ / /__ Principal Software Engineer/Server Architect
/_/ /_/\_, /___/\___\_\___/ Sun Microsystems GmbH, HRB München 161028
<___/ Sonnenallee 1, 85551 Kirchheim-Heimstetten
Geschäftsführer: Thomas Schroeder, Wolfgang Engels, Dr. Roland Boemer
Vorsitzender des Aufsichtsrates: Martin Häring
