Re: Control user Login ?

Andreas Wizemann wrote:
>
> Hi,
> is there a way to know at which time a user was last connected to a
> database (if he is currently NOT connected) ?
> Is there also a way to see how long a user has been connected ?
>
> Regards
> Andreas
> Andreas Wizemann

set audit_trail = true in init.ora
SQL> audit session

and query the DBA_AUDIT... views (and truncate sys.aud$ periodically)

v$session shows you who is currently on the system

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."