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