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
Printable View
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