SYSOBJROLEDEP catalog table

The SYSOBJROLEDEP table lists the dependent objects for each role. The schema is SYSIBM.

Table 1. SYSIBM.SYSOBJROLEDEP table column descriptions
Column name Data type Description Use
DEFINER
VARCHAR(128)
NOT NULL
 The authorization ID or role that created the object. G
DEFINERTYPE
CHAR(1)
NOT NULL
 The type of definer:
L
Role
blank
Authorization ID
 G
ROLENAME
VARCHAR(128)
NOT NULL
 Name of the role on which there is a dependency. G
DSCHEMA
VARCHAR(128)
NOT NULL
 Name of the schema of the dependent object. G
DNAME
VARCHAR(762)
NOT NULL
 Name of the dependent object. G
DTYPE
CHAR(1)
NOT NULL
 The type of the dependent object in DNAME:
B
Trigger
D
Database
E
Distinct type
F
User-defined function
H
Global variable
I
Index
J
JAR file
L
Role
M
Materialized query table
N
Trusted context
O
Stored procedure
Q
Sequence
R
Table space
S
Storage group
T
Table
V
View
X
Row permission
Y
Column mask
0 (zero)
Alias
 G
IBMREQD
CHAR(1)
NOT NULL
 A value of Y indicates that the row was provided with the Db2 product code. For all other values, see Release dependency indicators.

The value in this field is not a reliable indicator of release dependencies.

 G