Re: Access to Table from any Host on Internet

2002-07-05 Thread Ron Parker
GRANT SELECT ON DB.TABLE TO serf@'%' IDENTIFIED BY 'readonly'; I did "flush privileges", but still can't acess DB.TABLE with 'serf' unless I use GRANT statement that includes hostname of client from which I am executing command. I get this error using "serf@'%'": * connect() SQLException: ja

Access to Table from any Host on Internet

2002-07-05 Thread Ron Parker
I'm trying to execute a statement which will allow access to a table by a user from *any* client on the Internet. I enter something like this: GRANT SELECT ON DB.TABLE TO serf@'%' IDENTIFIED BY 'readonly'; Yet, I'm unable to access DB.TABLE unless I replace '%' with the hostname of the client

Re: Access to Table from any Host on Internet

2002-07-05 Thread Gelu Gogancea
- Original Message - From: "Ron Parker" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, July 05, 2002 12:25 PM Subject: Access to Table from any Host on Internet > I'm trying to execute a statement which will allow access to a table by > a user