InstantDB Project
About InstantDB
Project Mail Lists
Short History
Reporting Bugs
Screen Shots
3rd Party Examples
FAQs

Software
Downloads
Documentation
CVS Repositories
Roadmap
License

About Enhydra.org
Who We Are
News, Articles & Events
Getting Involved
Contact Us

Community
Demos
Contributions
Resources
Case Studies
On The Edge! -NEW-
Commercial Vendors

There is a solution which you guys could design and it would be quick.
You design a quick server - all it does is pass SQL and Resultsets (for
example) through a socket - 1 socket per client connection. Then, on Unix,
whichever user the server is executed on will handle the permissions
automatically. So the server uses the driver and the .prp file to make the
jdbc connection and it waits on a port for a socket connection. So this
"server" which is less than 200 lines of code creates a 3-tier(
architecture?) making any operating system blackbox. You would not have
change any of the other database code you have, it would be independant.
An addon I suppose to your existing software.
Wadda ya think ? Would you guys be willing to design something like this ?
It should take less than a week.

Please send comments - thanx =)

Robert Milewski  (716) 645-6164 x538
Research Engineer
Center of Excellence for Document Analysis and Recognition
SUNY Buffalo

http://www.cse.buffalo.edu/~milewski


On Mon, 30 Oct 2000, Peter Hearty wrote:

> Robert
> 
> AFAIK (and if I'm wrong - would someone out there please chip in and
> correct), there's no way to explicitly set UNIX style file permissions in
> Java. There are limited capabilities in the java.io.File class, but these
> are mostly interrogative.
> 
> I think that means that, if you intend to access a database from multiple
> accounts, it's either a matter of setting up a group with appropriate
> permissions or manually setting file permissions once the database has been
> created.
> 
> Any UNIX Guru's care to comment?
> 
> Regards
> 
> Pete
> 
> --
> 
> Peter Hearty                         peter.hearty@lutris.com
> Lutris Technologies (UK)        http://www.lutris.com
> ----- Original Message -----
> From: "Robert J Milewski" <milewski@cedar.buffalo.edu>
> To: <bugs@enhydra.org>
> Sent: Thursday, October 26, 2000 7:11 PM
> Subject: instantdb evaluation
> 
> 
> >
> > To whom this may concern,
> >    I am a lead design engineer evaluating java database engines for
> > one of our projects. While evaluating the latest release of your InstantDB
> > system in Solaris, I noticed that when I create or modify a table, the
> > permissions, user and group information from my umask is used on the file
> > for that table. This prevents other users from having read/write access to
> > that table. If there is something I have missed, please notify me ASAP. I
> > found your system easy to use, but I would not want to scrap it b/c of
> > improper handling of Unix permissions. Hopefully I missed something.
> > Thank you for your time. =)
> >
> >
> > Robert Milewski  (716) 645-6164 x538
> > Research Engineer
> > Center of Excellence for Document Analysis and Recognition
> > SUNY Buffalo
> >
> > http://www.cse.buffalo.edu/~milewski
> >
> >
> >
> 

-----------------------------------------------------------------------------
To unsubscribe from this mailing list, send email to majordomo@enhydra.org
with the text "unsubscribe instantdb" in the body of the email.
If you have other questions regarding this mailing list, send email to
the list admin at owner-instantdb@enhydra.org.