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 :-) --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php