<div>
if you don't have auditing turned on to collect logons then there is no &quot;last signed on&quot; information &nbsp;in 11gR2 and lower<br />
<br />
if you do have auditing on for logon then look in dba_audit_trail<br />
<br />
<br />
if you have 12c then &nbsp;dba_users has a last_login column
</div>


if you don't have auditing turned on to collect logons then there is no "last signed on" information  in 11gR2 and lower

if you do have auditing on for logon then look in dba_audit_trail


if you have 12c then  dba_users has a last_login column

<div>
&gt;&gt;oracle table keeps this audit information.thanks<br />
<br />
If you have auditing turned on and set to DB then it is SYS.AUD$. &nbsp;There are other locations for the audit records.<br />
<br />
I would start in the online docs:<br />
<a href="http://docs.oracle.com/cd/E11882_01/server.112/e10575/tdpsg_auditing.htm#TDPSG50000" rel="ugc">http://docs.oracle.com/cd/E11882_01/server.112/e10575/tdpsg_auditing.htm#TDPSG50000</a>
</div>


>>oracle table keeps this audit information.thanks

If you have auditing turned on and set to DB then it is SYS.AUD$.  There are other locations for the audit records.

I would start in the online docs:
http://docs.oracle.com/cd/E11882_01/server.112/e10575/tdpsg_auditing.htm#TDPSG50000 [http://docs.oracle.com/cd/E11882_01/server.112/e10575/tdpsg_auditing.htm#TDPSG50000]

<div>
<div class="content wysiwyg-content">
As part of the Security clean up i &nbsp;need a report listing users with accounts that have not been accessed in 90 days or greater. &nbsp;with the below fields.<br />
<br />
can you please tell me which oracle table keeps this audit information.thanks.<br />
1. &nbsp;User Name<br />
2. &nbsp;Last signed on date<br />
3. &nbsp;Last signed on time
</div>
</div>


As part of the Security clean up i  need a report listing users with accounts that have not been accessed in 90 days or greater.  with the below fields.

can you please tell me which oracle table keeps this audit information.thanks.
1.  User Name
2.  Last signed on date
3.  Last signed on time

oracle security

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.