Re: Forms/reports Application and DB security

Hi,
is this just for 10g ? I cant find dbms_monitor on 9i .

regards

2006/6/12, F.Castillo_at_hzd.hessen.de <F.Castillo_at_hzd.hessen.de>:
>
> Hi Muhammed
>
> you can use the dbms_monitor package (serv_mod_act_trace_enable) to enable
> tracing for all (future) sessions
>
> Like
>
> First: dbms_application_info.set_module( module_name => 'module',
> action_name => 'what I am doing' );
>
> then
>
> begin
> dbms_monitor.serv_mod_act_trace_enable (
> service_name => 'ora10g',
> module_name => 'module',
> action_name => dbms_monitor.all_actions,
> waits => true,
> binds => false,
> instance_name => null );
> end;
>
> You can take a look at
> http://www.oraconsult.de/index.php?option=com_content&task=view&id=30&Itemid=71.
> It's written in German but I think you can get an idea when looking at the
> code snippets
>
>
> Felix
>
> -----Ursprüngliche Nachricht-----
> *Von:* Muhammed Soyer [mailto:msoyer_at_gmail.com]
> *Gesendet:* Montag, 12. Juni 2006 08:08
>
> *An:* Castillo Sánchez, Félix (HZD)
> *Cc:* oracle-l_at_freelists.org
> *Betreff:* Re: Forms/reports Application and DB security
>
> Hi Castillo,
>
> What do you mean by future sessions ?
>
>
>
>
> 2006/6/12, F.Castillo_at_hzd.hessen.de < F.Castillo_at_hzd.hessen.de>:
> >
> > 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_at_gmail.com]
> > Gesendet: Freitag, 9. Juni 2006 15:11
> > An: Castillo Sánchez, Félix (HZD)
> > Cc: oracle-l_at_freelists.org
> > 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
> >
> >
> >
>

--
http://www.freelists.org/webpage/oracle-l