Anyone have script for pulling anyone not logged in sql last 90 days?

[vinman]

Hello all,
Since all this new SOX stuff is going on now i figured others have already implemented scripts to pull data such as who hasnt logged into sql in last 90 days so i thought i would check here to see. I have started implmenting auditing, of just the session info since that is all they are asking for so if anyone has any scripts or any helpful info please let me know. Also if anyone has any data on how much enabling auditing of connect session is going to add to the aud$ table that would be helpful as well.

thanks for the time

-Vinman

[abhaysk]

logon triggers or may be u can expire user if not used for 90 days...

Abhay.

[vinman]

i have auditing enabled, im just looking for some scripting that can pull out who hasnt logged in in say 90 days so we can track that for these SOX people. Something running query against dba_audit_session view. let me know if anyone has anything for this

thx
Vinman

[vinman]

Anyone have any help on scripts for extracting this info? Please let me know any help would be appreciated

thx
Vinman