SYSGROUP system table

Reference Manual
CHAPTER 15. System Tables

SYSGROUP system table

Column name

Column type

Column constraint

Table constraints

group_id

SMALLINT

NOT NULL

Primary key, foreign key references SYS.SYSUSERPERM. user_id

group_member

SMALLINT

NOT NULL

Primary key, foreign key references SYS.SYSUSERPERM. user_id

Column name	Column type	Column constraint	Table constraints
group_id	SMALLINT	NOT NULL	Primary key, foreign key references SYS.SYSUSERPERM. user_id
group_member	SMALLINT	NOT NULL	Primary key, foreign key references SYS.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.