Michael Handiboe <[EMAIL PROTECTED]> wrote:
>
> 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.
How did you try to change column name? What exactly error message did you get? What is
the output of SHOW GRANTS for user 'steve'?
>
>
> 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 :-)
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ [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]
