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