-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|