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@(protected)]
Gesendet: Freitag, 9. Juni 2006 15:11
An: Castillo S?nchez, F?lix (HZD)
Cc: oracle-l@(protected)
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.
--
http://www.freelists.org/webpage/oracle-l