Creating a Security/Login Application

Applications Control
#1

Hello,

I followed this tutorial (http://downloads.scriptcase.net/downloads/v5/manual/en_us/webhelp/manual_mp/05-Projeto/07-Seguranca.htm) to set up the security module based on “User / Group / App” principle and thus also created the proposed security db table structure.

After that I created a Control Application displaying a login form with User and Password fields.
As fas as I understand, the next step is to handle the onValidate event, in which I can activate the application via

sc_apl_status('<Application>','on');

But how do I that in respect to the “User / Group / App” principle?

And, after a successful login, how do I redirect to the menu application, where the authenticated user can navigate through the applications he is permitted for?

Any help appreciated!

Regards,
Sascha.

#2

Re: Creating a Security/Login Application

Okay, I now understood that the applications created by the security module do everything needed automatically.

Now I discovered a bug in the “tb_users” application:
Upon inserting a new record it says:

Error inserting:
Column ‘cod_group’ specified twice

where the according SQL statement is:

insert into tb_users_x_groups (cod_group, cod_group) values (’<user>’, ‘9’)

Where can I edit this insert SQL?

#3

Re: Creating a Security/Login Application

did you create all the necessary tables to run the module you choose ? users, group, application ?