Hi Rick,

Getting closer...

Does it matter that when I use JCrypt to encrypt 'masterkey' it
doesn't look the same as the password in security.fdb?

Nick

--- In Firebird-Java@yahoogroups.com, "Rick Fincher" <rnf@t...> wrote:
> 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@y...>
> 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
> >
> >
> >
> >
> >