[Lvlug] Re: java and mysql permissions

[Faber Fedor]

On 08/04/05 21:30 -0400, dann s washko wrote:
> I'm thinking there is a permissions difference when running an app that 
> accesses the database if that app is not run on the machine local to the 
> database, based upon the permissions I have suppled to each user.
> 
> A java applet or application can be run via the client-side version of 
> java.  Thus, this requires external permissions on the database.  I'm 
> basing my supposition on the fact that he is either using java on the 
> local machine or making use of java through a web browser, he has not 
> expressed otherwise.  Running a java application on an external system 
> would require that said system would be granted access to the database 
> either explicity providing permission to the host name, network address, 
> subnet or everyone via '%'.

The database doesn't know or care what the client is running (Java, M$,
etc.).  If you have SELECT and ALTER permissions for
luser at client_machine, then Larry User can connect from the
client_machine regardless of what he's running.

You *do* have permission set for luser at client_machine and not just
luser, right?

And the database is configured to accept networks sockets, right?

Those should be the only two things you need for him to connect.

-- 
 
Regards,
 
Faber Fedor
President
Linux New Jersey, Inc.
908-320-0357
800-706-0701

http://www.linuxnj.com