this is also true for roles with password .We have set the roles default for all sessions ..No diffrence ..
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