inactive users after certain period

[learning_bee]

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

[rajabalachandra]

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

[learning_bee]

ANY OTHER ADVISES ?????

THANKS

[pando]

go and read about profiles