A tabela SYSOBJROLEDEP lista os objetos dependentes para cada função.
O esquema é SYSIBM.
The SYSOBJROLEDEP table lists the dependent objects for each role.
The schema is SYSIBM.
| 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 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. |
G |
