systemgrouppermission


Description

The list of additional user accounts allowed to access a system group

Columns

Column Type Size Nulls Auto Default Children Parents Comments
mgm_id numeric 131089 null
account.mgm_id systemgrouppermission_user_fkeyR
systemgroup.mgm_id systemgrouppermission_group_fkeyR

The id of the SUSE Manager instance that contains this data
system_group_id numeric 131089 null
systemgroup.system_group_id systemgrouppermission_group_fkeyR

The id of this system group
account_id numeric 131089 null
account.account_id systemgrouppermission_user_fkeyR

The id of the user account
group_name varchar 64 √ null

The unique name of the system group
synced_date timestamptz 35,6 √ CURRENT_TIMESTAMP

The timestamp of when this data was last refreshed.

Indexes

Constraint Name Type Sort Column(s)
systemgrouppermission_pk Primary key Asc/Asc/Asc mgm_id + system_group_id + account_id

Check Constraints

Constraint Name Constraint
vn_systemgrouppermission_group_name (((group_name)::text <> ''::text))

Relationships

Close relationships within degrees of separation