Hola Juan
Using set_module has also the side effect to give us the possibility to
monitor and trace even future sessions.
Gracias
Felix
-----Ursprüngliche Nachricht-----
Von: Juan Carlos Reyes Pacheco [mailto:juancarlosreyesp@xxxxxxxxx]
Gesendet: Freitag, 9. Juni 2006 15:11
An: Castillo Sánchez, Félix (HZD)
Cc: oracle-l@xxxxxxxxxxxxx
Betreff: Re: Forms/reports Application and DB security
Hi Castillo
If you want to enable control by applications you can think in using
DBMS_APPLICATION_INFO.SET_MODULE( module_name => cXNombre, action_name =>
'Apertura' );
But I see this can be more complex, beacuse you must guarantee every
session had set this variables.
role with password is a better solution, unles I didn't understand your
comment.
--
//www.freelists.org/webpage/oracle-l