At 05/24/2002 07:14 AM (Friday), Riho-Rene Ellermaa wrote:

>In original script there was:
>
> CREATE VIEW USERS (USER_NAME) AS
> SELECT *
> FROM users2
> WHERE EXISTS (SELECT * FROM log_proc(users2.user_name));

Since it looks like the original view presents only the USER_NAME column, I
would change its definition to

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

and see if that helps.