Hi Roman,

Thanks a lot!!!

Your solution was just perfect, It was exactly what I
needed.

I already tested and It works very good from Windows
and Linux.

Thanks again,

Nairo Granados

--- pcam_again <p.cameron@...> wrote:

> --- 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
>
>
>

__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com