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]