You are here: Reference Information > SQL Reference Information > SQL System Tables > USERROLES System Table Description

USERROLES System Table Description

Description

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

Fields

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 1 if the role is currently active for the user; 0 otherwise.

Indexes

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

Foreign Keys

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