Re: Oracle Users

From: Matthias Gresz <GreMa_at_t-online.de>
Date: 1998/12/09
Message-ID: <74lu10$psj$2@news02.btx.dtag.de>#1/1

NoviC schrieb:
>
> First ..Sorry for my English
>
> We use for Acounting applicatian with Oracle ver. 7.1.8 and AIX ver. 3.2.5
> The server is IBM RISC 6000 with RAID 7137 and HACMP system.
>
> My question is :
> 1. How do we know for user oracle login ?? ( what's the command is )
> 2. How we can create only 1 (one) user oracle login for 1 (one) terminal
> only ??
>
> Thanks..

Run CATAUDIT.SQL as sys.
Then issue an 'AUDIT SESSION'.

After this, this query might help you:

SELECT

username,
userhost,
terminal,

to_char(Timestamp, 'DD-MM-YYYY HH24:MI') login_time, to_char(logoff_time, 'DD-MM-YYYY HH24:MI') logoff_time,

logoff_lread,
logoff_pread,
logoff_lwrite,
logoff_dlock

   FROM sys.dba_audit_session

HTH
Matthias

-- 
Matthias.Gresz_at_Privat.Post.DE

Always log on the bright side of life.
http://www.stone-dead.asn.au/movies/life-of-brian/brian-31.htm

Received on Wed Dec 09 1998 - 00:00:00 CST