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