[Lvlug] Re: java and mysql permissions

[dann s washko]

Faber Fedor wrote:
> On 08/04/05 18:02 -0500, Deep Kapadia wrote:
> 
>>So, even if this person is trying to run an applet on the box hosting
>>the MySql server, he will not be able to do so since the current
>>security policy of the Java virtual machine on the box does not permit
>>him to connect/resolve/accept connections through an applet.
> 
> 
> So having a database username and password aren't enough?  I'm thinking
> along the lines of a Perl DBI or ODBC connection: if you've got the
> database username and password correct, you can connect to the database.
> Whether the database accepts connections over the Internets [sic] or locally
> is a database configuration issue.
> 

Right.  I do believe the problem is the way I have permissions on the 
database.


> You're implying that there's another layer to consider when using a Java
> app?
> 

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 '%'.

-- 
Dann S. Washko
The Linux Link Tech Show
Check Us Out Weekly:  Live/Stream/Podcast

      http://www.thelinuxlink.net

The Linux Link Web Radio Portal
    TLLTS -- LUGRadio -- The LinuxBox Show


get slack (www.slackware.com) and get happy