Subject | Re: CREATE USER through Java |
---|---|
Author | Bill Oliver |
Post date | 2004-08-30T15:14:16Z |
Thank you both for the good answers. One of these approaches should
work well for me.
-bill
work well for me.
-bill
--- In Firebird-Java@yahoogroups.com, <brenmcguire@t...> wrote:
> I did it in my application (Medi) connecting directly to the
> "security.fdb" file and using a Java version of crypt.
> Take a look at:
> http://sourceforge.net/projects/medi
> download the "javatools-mod" package and inspect
> "javatools.db.util.FirebirdUserCreator"
and "javatools.db.util.JCrypt"
> files.
> Notice that the "javatools-mod" library is LGPL.
> Ciao
> Antonio Petrelli
>
> Roman Rokytskyy wrote:
>
> >>How do you create a new user through Jaybird? Ideally, I would
want
> >>to be able to call executeUpdate ("CREATE USER BOB bobpassword");
or
> >>something similar. I see how to create a new database through
> >>Jaybird, but not how to add a new user to that database.
> >
> >
> >At present officially not possible. You can try to experiment with
the
> >services API that is already in code, however it is not officially
> >supported/tested.
> >
> >>I tried inserting a user record into the security.fdb database,
but
> >>the password shows up as plain text, and I can't authenticate with
> >>the user I just created.
> >
> >
> >Ask for the algorithm of password encryption (as far as I remember
this
> is
> >simple Unix crypt algorithm). There are components in C/C++ that
do this
> >(ask in Firebird-Support group). Then instead of writing password
in
> plain
> >text put the en-crypt-ed one. It should work.
> >
> >>Creating the user through ISQL is not helpful to me.
> >
> >
> >You can also fork a gsec command-line tool for this.
> >
> >Roman
> >