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	string	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

string

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

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