USERROLES System Table Description

Description

Information about SQL roles defined in the database and users to which the role is granted.

Field Type Description

Field	Type	Description
USERNAME	varchar (128)	Specifies a user in the database.
ROLESCHEMA	varchar (128)	The schema in which the role was created.
ROLENAME	varchar (128)	The name of the role being granted.
OPTIONS	integer	1 if the user has the right to `GRANT` this role to other users; 0 otherwise.
DEFAULTROLE	integer	1 if the role is active for the user by default when the user connects to the database; 0 otherwise.
ACTIVE	integer	Deprecated

USERNAME

varchar (128)

Specifies a user in the database.

ROLESCHEMA

varchar (128)

The schema in which the role was created.

ROLENAME

varchar (128)

The name of the role being granted.

OPTIONS

integer

1 if the user has the right to GRANT this role to other users; 0 otherwise.

DEFAULTROLE

integer

1 if the role is active for the user by default when the user connects to the database; 0 otherwise.

ACTIVE

integer

Deprecated

Primary Index: USERROLES..PRIMARY_KEY on fields: USERNAME, ROLESCHEMA, ROLENAME
Secondary Index: ROLE_USER on field: USERNAME

Foreign Key : (ROLESCHEMA,ROLENAME) references ROLES(SCHEMA,ROLENAME)
Foreign Key: (USERNAME) references PASSWORDS(USERNAME)