Re: granting does not give the correct privileges

[Paul DuBois]

At 9:52 -0700 9/24/02, Nestor Florez wrote:
>Is this an error in Mysql?
>I do the follwing command from a shell
>        "grant insert on mydb.* to username@localhost identified by user
>'pwd';"
>When I check the permissions the insert_priv field on user table of mysql db
>is set to 'N'.
>
>Why is that?

Because the user table holds *global* privileges only.
You didn't grant a global privilege, you granted a database-level
privilege.  Check the db table instead of the user table.

>   I can change the privileges by giving an update command.
>
>
>Any ideas?,
>
>
>Nestor :-)