Multiple Maxresults, Maxscanrows, and Maxlocktime Values

Which "maxresults" or "maxscanrows", or "maxlocktime" applies to a user who is in more than one gro

Problem

Which "maxresults" or "maxscanrows", or "maxlocktime" applies to a user who is in  more than one group?

Solution

The limit that affects a user is the highest maxresults or maxscanrows or maxlocktime value of all the groups to which a user belongs.

For maxresults, and maxscanrows, and maxlocktime the value "unlimited" is not a limit. If a user is in a group where either value is set to "unlimited", she is still limited by the the highest limits of that setting of the other groups to which she belongs. A user's commands are truly unlimited only when she belongs to no groups, or when all the groups she belongs to have maxresults or maxscanrows or maxlocktime set to "unlimited".

Any hardcoded setting overrides the group "unlimited" setting. For example, if user "mike" belongs to the "programmers" group, which has a maxresults setting of 10000, and the "p4admin" group, which has a maxresults setting of "unlimited", his limit is 10000. For this reason we recommend that the settings for maxresults and maxscanrows maxlocktimeare set to an absolute high value for superuser groups, for example:

	Group:       superusers
	Maxresults:  10000000
	Maxscanrows: 20000000
	Maxlocktime: 1800000