How to find out whether a user logged into the database in last 90 days ?

[san]

Hi All ,

I am trying to find out users who have not accessed the database in last 90 days and drop them from the database....

Please let me know how can I find out this...and also I want to reset/change the passwords every 90 days in the database...how can I automate this ?

Thanks in advance...

San

[jlakhani]

You should look into profiles.

[gbrabham]

Profiles is good or you could also use logon triggers and create
yourself a little audit type table that is written to as users logon and logoff the database (if that is what you are trying to do)

..........
LOGON and LOGOFF triggers can be associated with the database or with a schema. Their attributes include the system event and username, and they can specify simple conditions on USERID and USERNAME.

LOGON triggers fire after a successful logon of a user.

LOGOFF triggers fire at the start of a user logoff.

Gregg

[san]

Profile for each of the users is default....., Limit for all the resource names in dba_profiles in unlimited....

Any other view that stores login & logout history ?

Thanks,
San

[TomazZ]

There are no views that store logon/logoff history by default.
But you can make it yourself as Gregg sugested!
Also 'you can look in profiles' does not mean you should look in view dba_profiles and everything is there. It means you should open your documentation on profiles and find how to apply password expiration.