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

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] &

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 firs

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

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 upda