Users not logged on last 30 days

[M.Shakeel Azeem]

Dear all,
I want to determine the users not logon for the last 30 days
can anybody help me in this regard?

thanx in advance

[girirajdba]

Hi,
First of all create a table with fields 'user' & 'sysdate'
then create a database trigger which would fire after login of any user & insert the loggedin info into the above create table like user & time

[lesstjm]

Or you can enable the database auditing to capture every login