USERROLES System Table Description

Description

Information about SQL roles defined in the database and users to which the role 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.

With the release of NuoDB 3.2, the ACTIVE column has been deprecated, and must no longer be used.

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)