Limits and ranges of ID numbers

Table 14-2 describes the valid ranges for the ID types.

Table 14-2: Ranges for ID types

ID type

Server limits

Logins per server (suid)

2 billion plus 32K

Users per database (uid)

2 billion less 1032193

Groups or roles per database (gid)

16,384 to 1,048,576

Figure 14-1 illustrates the limits and ranges for logins, users, and groups.

Figure 14-1: Users, groups, and logins available in Adaptive Server

Image shows numbers for IDs in Adaptive Server: User IDs are from -32768 to 16383, Group or role IDs are from 16383 to 1048576. SUIDs are from -32768 to 2 billion.