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