inactive users after certain period

Hi all,

How can inactive or lock the users if let's say if he is not login the database for 365 days???

please advise and thanks

you can have a trigger that fires every time an user logs in
that updates a table with last login time.

may be another schedule to lock the user based on this table.

this may not be the optimal. because you will have to
wait another 365 days.

is there any view to get the last login time? anybody?

-Raja

ANY OTHER ADVISES ?????

THANKS

go and read about profiles