Hi Nick,

Below is a code example from Phil, who implemented JCrypt to encode
passwords. I 'll put this in the FAQ.

Rick

> You need to implement the crypt function to generate
> the password.
>
> I have given an example bellow of the calls to the
> crypt function.
>
> Using gsec, a user can see the processes running
> and get the new and
> old password !
>
> To create a user, generate the password, then
> create an entry in the
> security database for the user.
>
> The Firebird and Interbase security database is
> named isc4.gdb, V7
> uses admin.ib.
>
> // Create the user and set the password
>
> // Get the encrypted password.
> String s1 = JCrypt.crypt("9z", sLoginPassword);
> // Remove the salt
> s1 = s1.substring(2, s1.length());
> String s2 = JCrypt.crypt("9z", s1);
> // Remove the salt
> s2 = s2.substring(2, s2.length());
> sLoginPassword = s2;
>
> I have put the impl of JCrypt into the files
> section,
>
> Good Luck,
>
> From,
>
> Phill
>


----- Original Message -----
From: "Nick Sydenham" <nsydenham@...>
To: <Firebird-Java@yahoogroups.com>
Sent: Friday, February 20, 2004 6:19 AM
Subject: [Firebird-Java] Re: Create users or roles


> Rick,
>
> That helps a lot, unfortunately I don't have much of an idea how to
> use the JCrypt class. What salt does Firebird use if at all?
>
> Nick
>
> --- In Firebird-Java@yahoogroups.com, "Rick Fincher" <rnf@t...> wrote:
> > Hi Nick,
> >
> > Yes, you just have to work with the user database, typically
> isc4.gdb. The
> > hardest part is the encoding of the passwords.
> >
> > A package is in the download area of this group on yahoogroups.com that
> > handles encoding/decoding the passwords for you.
> >
> > Roles are stored in the system database RDB$ROLES.
> >
> > Hope this helps,
> >
> > Rick
> >
> > ----- Original Message -----
> >
> > > Is it possible using Java to create and manipulate users and roles
> > > within Firebird?
> > >
> > >
> > >
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>