Number of logins

Table 2-3 lists the limits for the number of logins, users, and groups for Adaptive Server.

Table 2-3: Limits for number of logins, users, and groups

Item

Version 12.0 limit

Version 12.5 limit

New range

Number of logins per server (SUID)

64K

2 billion plus 32K

-32768 to 2 billion

Number of users per database

48K

2 billion less 1032193

-32768 to16383; 1048577 to 2 Billion

Number of groups per database

16K

1032193

16384 to 1048576