ciao Marco,
The problem with a trial that I made is with the password of the user created... (could be solved with the Lost your password? from the customer.pl ?)
In my environment there is no password problem. I can temporarily set a default password and I can instruct the customer to change the password on first login.
insert into customer_user (login,email,customer_id,first_name,last_name,valid_id,create_time,create_by,change_time,change_by) values ('prova', 'prova@prova.it', 'prova', 'p', 'p', 1, sysdate(), 1, sysdate(), 1)
I did a test to try to understand what database modifications are made when I add a customer user. I found modifications in two tables: customer_users -> one row customer_preferences -> many rows Doing an insert like you propose is enough? Or I also have to insert entries on the customer_preferences table? Thanks, Alessandro Cortiana