Re: can you help me?

From: Tom Zamani <tomz_at_redflex.com.au>
Date: Thu, 9 Dec 1999 14:46:10 +1100
Message-ID: <82n8gf$d9t$1@perki.connect.com.au>

found it.
select upper(osuser)

    into username
    from sys.v_$session
    where audsid=userenv('SESSIONID');

Tom Zamani <tomz_at_redflex.com.au> wrote in message news:82n5hi$a0t$1_at_perki.connect.com.au...
> I have got an oracle 8.0.5 on linux and clients on NT 4,
> I need to be able to get the user id of the person who has submited any
job
> to the server.
>
> Every client logs into one schema, when they modify data I need to record
> who has done it. I can not use the Schema name as every one is using the
> same schema.
> Any idea as How I can get around it .
> Thanks Tom
>
>
Received on Wed Dec 08 1999 - 21:46:10 CST