granting does not give the correct privileges

2002-09-24 Thread Nestor Florez
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? I can change the privileges by giving an

Re: granting does not give the correct privileges

2002-09-24 Thread 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?

Re: granting does not give the correct privileges

2002-09-24 Thread Josh Trutwin
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'. This always gave me a lot of confusion at first. If

RE: granting does not give the correct privileges

2002-09-24 Thread Luc Foisy
Independent table permissions are stored in the 'db' table. Base user permissions are stored in the 'user' table. -Original Message- From: Nestor Florez [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 12:52 PM To: [EMAIL PROTECTED] Subject: granting does not give

Re: granting does not give the correct privileges

2002-09-24 Thread Franz Alt
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? I can change the privileges by giving