Re: How could I extract user name?

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Tue, 21 Mar 2000 12:44:44 -0000
Message-ID: <8b7qrt$384$1@soap.pipex.net>

where username = '<APPLICATION USERNAME> in this case.

generically

where type != 'BACKGROUND' gives you non bvackground logged on users.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Screamer" <mflopes_at_bigfoot.com> wrote in message news:8b7fi3$j2$1_at_duke.telepac.pt...
> select osuser, terminal from v$session
> where ......
>
> If anyone can help on the where clause i would appreciate.
>
> Gennady <gennadyb_at_halcosoftware.com> wrote in message
> news:38d11e4e$0$848_at_fountain.mindlink.net...
> > Hello,
> > I have Oracle 8.0.5 DB with application schema and 2 real Oracle
Client
> > users
> > with DBA privilege. How can I extract real client user name when he
> > connected as application schema
> > user?
> > Thanks,
> > Gennady
> >
> >
> >
>
>
Received on Tue Mar 21 2000 - 06:44:44 CST