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)