Re: Didn't get the information from the LAPTOP

Hi,

with regards to my earlier post,I like to say Is that possible that I am logging into the wrong database via Laptop, that's why I am not getting rows?

Regards

MArjina

marjina98_at_hotmail.com wrote in message news:<24bfee06.0404251922.31dc29fb_at_posting.google.com>...
> Hi,
>
> I would like to say that I not wanted to use the auditing.
> I know its advantages, but our requirement is different.
> I am still facing the initial problem which I discussed.
> Could you plz check it?
>
> Regards
>
> Marjina
>
>
>
> "Douglas Hawthorne" <douglashawthorne_at_yahoo.com.au> wrote in message news:<AKDic.8310$qq6.5436_at_news-server.bigpond.net.au>...
> > <marjina98_at_hotmail.com> wrote in message
> > news:24bfee06.0404240750.1959b6dd_at_posting.google.com...
> > > Hi,
> > >
> > > I am using the AFTER LOGON ON DATABASE Trigger in order to get the
> > > Users information.
> > > But When I query the Table &#8220;client_history&#8221; from my
> > > LAPTOP. I didn&#8217;t get any information from the
> > > &#8220;client_history&#8221; table.
> > >
> > > I like to say that, my client is on the Laptop and
> > > the Server too.
> > >
> > > However when I connect to Server via my PC (normal client server
> > > connection), I got the data via query the table.
> > >
> > > I am using 8.1.7 version.
> > > Could some one explain why I didn&#8217;t get the rows from laptop?
> > >
> > > Regards
> > >
> > > Marjina
> > >
> > >
> > >
> > >
> > >
> > >
> > > CREATE OR REPLACE PROCEDURE Login
> > >
> > > as
> > >
> > > v_client varchar2(40);
> > > v_ausid number;
> > >
> > >
> > > BEGIN
> > >
> > >
> > >
> > > select SYS_CONTEXT('USERENV', 'OS_USER') into v_client from dual;
> > >
> > > select SYS_CONTEXT('USERENV','SESSIONID') into v_ausid from dual;
> > >
> > >
> > > INSERT INTO client_history (hclient,hausid,)
> > > VALUES
> > > (v_client,v_ausid);
> > >
> > > commit;
> > >
> > > END Login;
> > >
> > > /
> > >
> > >
> > >
> > >
> > > CREATE OR REPLACE TRIGGER logintrig
> > > AFTER LOGON ON DATABASE
> > > CALL login
> > >
> > > /
> >
> > Marjina,
> >
> > Did you know you can do the same thing with the AUDIT command? See p.8-114
> > of the 'Oracle 8i SQL Reference".
> > AUDIT CREATE SESSION;
> >
> > The information you want is stored in the SYS.AUD$ table with views
> > DBA_AUDIT_SESSION especially (see p.2-99 of the "Oracle8i Reference")
> > SELECT
> > os_username,
> > sessionid
> > FROM
> > dba_audit_session
> > ;
> >
> > Douglas Hawthorne
Received on Mon Apr 26 2004 - 23:45:34 CDT