When a user with full priveledges needs to login in single-user mode to edit the schema, is there a way to force logout all other users? Many people here exit IJC without closing the connection, making it difficult to administer the database.
You can see who is logged in (use the Current Users window - available from the Window menu), but you currently can't log them out. We plan to add the ability for and admin to force the logout of a user, but this obviously involves some level of risk so would need to be done carefully.
If you currently want to log a user out you can do this by setting the value of the LOGIN_TIME column in the IJC_USERS table to null directly in the database. But of course check first that they really are not using IJC!
In IJC 2.2 an administrator can now use the Current users window to log users out.
Thanks Tim. This will be a big help.