Michael Widenius wrote:
>Alexander> To say it different mysql.* is Admin space not User space
>In practice there isn't really a big difference.
Mark this for further discussions :)
>Alexander> While CREATE and DROP can be considered usefull for some recovery tasks,
>Alexander> nothing in the Universe can let me believe anyone, but MySQL developers
>Alexander> needs ALTER_Priv.
>In this case you are actually wrong. To quite 'SQL 99 Complete,
>Really', page 282:
>'Many vendors have added their own privileges to the SQL standard...'
>The most popular non-standard Privilege is 'GRANT ALTER'.
GRANT ALTER ON mysql.* TO ...;
GRANT ALTER ON user_db.* ...
I don't want to be able to ALTER mysql.user ADD COLUMN ..., DROP COLUMN ...
And I can't see why any non mysqld-developer should have this Priv.
SQL 99 is special case. I share oppinion that it completely brokes
Relational Model and applies more to OODBMS them RDBMS.
I'm affraid soon it will split DB servers into 2 mainstreams - SQL99 and