Hi,
Here is the simplest test case I could boil this down to. I'm running
this in 5.0.51a on RHEL4.
Preconditions:
- mysql.user only contains root user
- mysql.db is empty
- mysql.tables_priv is empty
- mysql.host is empty
I login as root, and run the following:
CREATE TABLE test.foo (
id int unsigned auto_increment,
name varchar(255),
PRIMARY KEY (id)
);
CREATE USER [EMAIL PROTECTED];
GRANT SELECT, INSERT, UPDATE, DELETE ON test.foo TO [EMAIL PROTECTED];
FLUSH PRIVILEGES;
Now I login as [EMAIL PROTECTED], and run "SHOW DATABASES". I only see
information_schema. If I try to "USE test" or "SELECT * FROM test.foo",
I get the following error:
ERROR 1044 (42000): Access denied for user 'test'@'localhost' to
database 'test'
Now I login as root again, and execute the following:
GRANT SELECT ON test.* TO [EMAIL PROTECTED];
FLUSH PRIVILEGES;
Now I switch back to [EMAIL PROTECTED] Now "test" shows up when I do
"SHOW DATABASES", and I can "SELECT * FROM test.foo". However, if I try
"INSERT INTO test.foo SET name='bar'", I get the same error again:
ERROR 1044 (42000): Access denied for user 'test'@'localhost' to
database 'test'
It's as if table-level permissions are being completely ignored, and
only database level permissions are kicking in.
I have been unable to reproduce on my FC9 box (also 5.0.51a) or my OSX
box (also 5.0.51a). This leads me to believe it's something external,
such as a linked library or a configuration file. I've looked at the
config - can't see anything too special there - and I just don't know
enough about this to pontificate on potential issues with linked libraries.
Wondering if anyone can help me out, as I am about ready to pull all of
my hair right out of my head! I have searched Google repeatedly, and
have skimmed through all bugs containing the word "grant" reported in
version 5, and can't find anything.
Any help is greatly appreciated!
Thanks,
Taylor
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
