Restrict Number of Users per Company

LewisJames

I have a client that wants to restrict the number of user sessions per company. He wants to allow 10 user sessions open in one company, 12 in another etc. Has anyone done this?

ara3n

Create a table with pk company name, User ID.


In GL Setup have max Number of users field.


OnCompanyOpen trigger in CU 1 insert record into the table and also check how many records are in the table and if goes over max number of Users and error out.


OnCOmpanyClose you can delete the record for that user.


Some client will crash (happens rarely) but in order to compensate for that.

OnCOmpanyOpen check and make sure all the users in the new tables are actually logged in (session table).

30 min mod.

garak

Note: User with "Super" permissions (for example YOU) should be ever have the right to connect ;-)

ara3n

oh and the table should be company independant or you could just have User ID as a field and don't need company because it will be separate table for each company.

garak

like written in this post;-)