Whether a Oracle DB user account has logged in the Oracle Database?
776954Mar 31 2011 — edited Apr 1 2011Hi all,
I'm using Oracle Financials 12.1.2. I'd like to ask, if I haven't turned on the audit trail on Oracle DB, in what ways I can check whether a DB user account has logged in the Oracle Database?
e.g. I've tried this SQL statement but it seems that it is a snapshot instead of full picture of the whole database throughout the whole time about which DB user logged in this database before.
select * from dba_hist_active_sess_history;
Is there any ideas like this can check? Thanks.