It has been Clarity Team owner's/Manager's wish to serve Customers/Users in best possible way. And it's always helpful to get feedback/suggestions from Users who uses Clarity the most. Clarity access logs are helpful but they give IP address not the user's id.
Clarity provides a field LOGIN_COUNT in CMN_SEC_USERS table, which I thought could be of use, but I couldn't find any configurable option to have login count stored in the table. So just thought of having a simple trigger to do this job.
Steps :
1. Open Insert Trigger of CMN_SESSIONS Table
2. Add Following piece. ( This code is for Oracle, for MS SQL it's similar thing to do )
UPDATE CMN_SEC_USERS
SET LOGIN_COUNT = NVL(Login_count,0) + 1
WHERE id = :NEW.USER_ID;
* Revisit this trigger after every SP/FP or Upgrade if this piece needs to added again.
Subscribe to:
Post Comments (Atom)
Posts
I want to know whether its valid usecase to allow same user login from different places but same time. During developement we used to login using same user id at the same time. Clarity allows to do that. Any inputs on this as you are talking on sessions?? Thanks
ReplyDelete