A tabela SYSROLES contém uma linha para cada função.
O esquema é SYSIBM.
The SYSROLES table contains one row for each role.
The schema is SYSIBM.
| Column name |
Data type |
Description |
Use |
| NAME |
VARCHAR(128)
NOT NULL |
The name of the role. |
G |
| DEFINER |
VARCHAR(128)
NOT NULL |
The authorization ID or role that defined this role listed in the NAME column. |
G |
| DEFINERTYPE |
CHAR(1)
NOT NULL |
The type of definer:
- L
- Role
- blank
- Authorization ID
|
G |
| CREATEDTS |
TIMESTAMP
NOT NULL |
The time when the role is created. |
G |
| RELCREATED |
CHAR(1)
NOT NULL |
The release of Db2 that is used to create the role.
See Release dependency indicators for the values. |
G |
| REMARKS |
VARCHAR(762)
NOT NULL |
A character string that is provided using the COMMENT statement. |
G |
| IBMREQD |
CHAR(1)
NOT NULL |
A value of Y indicates that the row came from the basic machine-readable material (MRM) tape.
For all other values, see Release dependency indicators.
The value in this field is not a reliable indicator of release dependencies.
RELCREATED should be used instead. |
G |
