[Lvlug] Re: java and mysql permissions
faber at linuxnj.com
Sat Apr 9 10:12:32 EDT 2005
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
And the database is configured to accept networks sockets, right?
Those should be the only two things you need for him to connect.
Linux New Jersey, Inc.
More information about the Lvlug