Chapter 14: Managing Adaptive Server Logins, Database Users, and Client Connections
Viewing server limits for logins, users, and groups
Table 14-3 lists
the global variables for the server limits of logins, users, and groups:
Table 14-3: Global variables for 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 user ID
|
16384
|
@@maxgroupid
|
Highest group 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
|
Copyright © 2005. Sybase Inc. All rights reserved.
|
|
View this book as PDF 