--- In Firebird-Java@yahoogroups.com, "Roman Rokytskyy"
<rrokytskyy@a...> wrote:

> Hi,
>
> > I would like to know if is possible to create Users in a Firebird

1.5

> > database from a JSP or a JavaBean...
>
> No, currently it is not possible to create users directly. However

you

> can connect to security.fdb (or what's the new name of isc4.gdb) and
> insert users with SQL. You will have to implement password encoding
> algorithm in Java.
>
> Best regards,
> Roman Rokytskyy

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