Table 14-3 lists the global variables for the server limits of logins, users, and groups:
Name of variable |
What it displays |
Value |
|---|---|---|
@@invaliduserid |
Invalid user ID |
-1 |
@@minuserid |
Lowest user ID |
-32768 |
@@guestuserid |
Guest user ID |
2 |
@@mingroupid |
Lowest group or role user ID |
16384 |
@@maxgroupid |
Highest group or role user ID |
1048576 |
@@maxuserid |
Highest user ID |
2147483647 |
@@minsuid |
Lowest server user ID |
-32768 |
@@probesuid |
Probe server user ID |
2 |
@@maxsuid |
Highest server user ID |
2147483647 |
To issue a global variable, enter:
select variable_name
For example:
select @@minuserid ----------- -32768
