Re: Didn't get the information from the LAPTOP

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 Sun Apr 25 2004 - 22:22:25 CDT