Limit User Connections
Hi, We are running Informix 12.10.FC9W1X1 on Solaris. Is there a way to limit the number of DB connections based on User ID? Each user connects to the DB using their own user ID so we are not using connection pools. We want to limit on the Informix side and set a max number of connections per user id. We recently had an application that spun out of control and made thousands of connections to the DB. We want to prevent this type of issue. Thank You, --Dave
Hi Dave.
I see this never had a response. Here is one approach:
CREATE PROCEDURE public.sysdbopen()
DEFINE session_count SMALLINT;
IF USER != 'informix' THEN
SELECT COUNT(*)
INTO session_count
FROM sysmaster:syssessions
WHERE username = USER;
IF session_count > 3 THEN -- set limit here
RAISE EXCEPTION -746, 0, 'Maximum sessions exceeded';
END IF
END IF
END PROCEDURE;
Regards,
Doug Lawry
Brilliant, just set the limit higher than 3 *lol* sysdbopen procedure allows to do tons of really nice things!
Thank you for the idea to use sysdbopen. I appreciate the input.