Re: Help required for system database trigger

On Apr 10, 11:05 pm, sybra..._at_hccnet.nl wrote:
> On 10 Apr 2007 03:37:52 -0700, "kishanthak..._at_gmail.com"
>
>
>
> <kishanthak..._at_gmail.com> wrote:
> >On Apr 9, 5:29 pm, sybra..._at_hccnet.nl wrote:
> >> On 9 Apr 2007 04:22:31 -0700, "kishanthak..._at_gmail.com"
>
> >> <kishanthak..._at_gmail.com> wrote:
>
> >> >I will be highly obliged if any one can help me on
>
> >> >Creating Database trigger for event of database login.
>
> >> >We have Oracle9i Enterprise Edition Release 9.2.0.4.0 -
> >> >ported on Redhat Linux ES rel. 4.
>
> >> >My SPECIFIC Requirement is
>
> >> >I want to trap the 'log in' event which is NOT initiated by
> >> >Oracle forms, Oracle reports and Oracle Plsql.
>
> >> >i.e. any 'login' other than these programs from windows98/windowsXP/
> >> >Windows2000 should be restricted.
>
> >> >I am unable to find any database function which returns this program
> >> >names.
>
> >> >some hint on the matter will really be helpful.
>
> >> >Thanx in Advance
>
> >> >Kishan Thakker
>
> >> convert the code to a stored procedure, owned by system,
> >> and just issue
> >> select program
> >> from v$session where sid in (select sid from v$mystat)
> >> or better still get the session sid from the sys_context function, and
> >> you are there.
> >> I would assume sys_context is capable of getting the program column
> >> from v$session, but I leave it to you to look up the sys_context
> >> function in the sql reference manual.
>
> >> --
> >> Sybrand Bakker
> >> Senior Oracle DBA
>
> >Dear Sybrand,
>
> >You are absolutely right. V$SESSION is not showing any thing in
> >'PROGRAM' column.
> >Instead 'MODULE' column is showing some details like 'T.O.A.D.' in
> >case I 'log in' from TOAD.
> >but is not showing any name if I 'log in' from Form or Reports.
>
> >any suggestion ?
>
> >regards
>
> >Kishan Thakker
>
> Modern versions of Developer run from an application server.
> You could simply set up sqlnet.ora on the server with tcp.valid_nodes
> or set up connection manager to do the same.
> In both cases you don't need a trigger anymore.
>
> --

thanx for reply. to be more precise we are working in a environment where middle tier application is not there. Its purely client server environment. Hence dependency of trigger cannot be avoided.

any other solution if possible ?

Kishan Thakker Received on Thu Apr 12 2007 - 06:09:45 CDT