You can control resources available to users with Sybase IQ User Administration, which lets you limit the number of connections to a database for all users or for an individual user, set password expirations, and lock out individual users so that they cannot connect to the database. See “Managing IQ user accounts and connections”.
For more information on settings that affect memory and other resources available to user connections, see Chapter 4, “Managing System Resources” in Sybase IQ Performance and Tuning Guide.