What do you mean by future sessions ?
Using set_module has also the side effect to give us the possibility to monitor and trace even future sessions.
-----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. -- http://www.freelists.org/webpage/oracle-l