User privileges on a database ... really stuck!

[Michael Handiboe]

Hello List Meisters.

I have the MySQL Reference Manual (the brown book), 1st Edition,
and it is a mighty fine book.
On p256, I follow the examples, but for a user who's supposed
to have access to a single database ('cabs') with the following
privileges:
        SELECT, REFERENCES, INDEX, ALTER
        ( 'ALTER' to allow changing column names, right?)
I can get the 'mysql.db' table to look right and it is shown here:

mysql> select * from db where User = 'steve';
+-----------+------+-------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+
| Host      | Db   | User  | Select_priv | Insert_priv | Update_priv | 
Delete_priv | Create_priv | Drop_priv | Grant_priv | References_priv | 
Index_priv | Alter_priv |
+-----------+------+-------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+
| %         | cabs | steve | Y           | N           | N           | 
N           | N           | N         | N          | Y               | 
Y          | Y          |
| localhost | cabs | steve | Y           | N           | N           | 
N           | N           | N         | N          | Y               | 
Y          | Y          |
+-----------+------+-------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+
2 rows in set (0.06 sec)

This is supposed to do it, right?  But when steve logs in, he cannot 
change a column name.

Here's my 'mysql.user' table:

mysql> select * from user where User = 'steve';
+-----------+-------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+
| Host      | User  | Password         | Select_priv | Insert_priv | 
Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | 
Shutdown_priv | Process_priv | File_priv | Grant_priv | 
References_priv | Index_priv | Alter_priv |
+-----------+-------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+
| %         | steve | 6bb528655ff3f6f2 | N           | N           | N 
          | N           | N           | N         | N           | N 
           | N            | N         | N
    | N               | N          | N          |
| localhost | steve | 6bb528655ff3f6f2 | N           | N           | N 
          | N           | N           | N         | N           | N 
           | N            | N         | N
    | N               | N          | N          |
+-----------+-------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+
2 rows in set (0.00 sec)

This is all steve needs to access a single database, right?
I flushed privileges, even though I used the GRANT commands
and in frustration, I used INSERT INTO as well (and flushed),
but it still ''won't work''.  I do not want steve to be able
to GRANT privileges, either.
If this is a simple fix, could someone please educate me :-)

Thanks.
M H
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]