Re: User permissions error on CREATE TABLE

2004-05-16 Thread Randall Perry
Never mind. Didn't have 'localhost' in Db table 'Host' field for the database. > I've got a user, joe, who has all privileges on database 'joe' except GRANT. > I gave permissions to joe using this command: > GRANT ALL ON joe TO [EMAIL PROTECTED] > > But if I'm logged in as joe to the joe db a

User permissions error on CREATE TABLE

2004-05-16 Thread Randall Perry
I've got a user, joe, who has all privileges on database 'joe' except GRANT. I gave permissions to joe using this command: GRANT ALL ON joe TO [EMAIL PROTECTED] But if I'm logged in as joe to the joe db and try to create a table, I get the error: ERROR 1142: create command denied to user: '[E