Hi!

I'm successfully using Ivan Prenosil's "Enhanced isc4" script for my Interbase 6.
(http://www.volny.cz/iprenosil/interbase/ip_ib_isc4.htm)
Now some of my customers are installing Firebird (1.0.0.794) and running into problems.

In original script there was:

CREATE VIEW USERS (USER_NAME) AS
SELECT *
FROM users2
WHERE EXISTS (SELECT * FROM log_proc(users2.user_name));

Interbase accepted it, but Firebird complained about number of columns not matching. When I changed (USER_NAME) with (USER_NAME,PASSWORD,.......)
- contains all columns - I got over this problem.
But after I run the script successfully I can't login into Firebird anymore - I get error "user not defined".

Is there anyone who also uses this script and works with Firebird? I realy need this script as it allows me to let users change their passwords and adds some security.
Or must I to put onto my setup screen: "Firebird not supported".


Riho-Rene Ellermaa
senior programmer
Hansabank