Sybase Adaptive Server Anywhere - SYSGROUP System Table

Chapter 15 System Tables
1013
SYSGROUP system table
Column name Column type
Column
constraint
Table constraints
group_id UNSIGNED
INT
NOT NULL Primary key, foreign
key references
SYSUSERPERM.user_
id
group_member UNSIGNED
INT
NOT NULL Primary key, foreign
key references
SYSUSERPERM.user_
id
There is one row in SYSGROUP for every member of every group. This
table describes a many-to-many relationship between groups and members.
A group may have many members, and a user may be a member of many
groups.
group_id The user number of group.
group_member The user number of a member.