SYSCAT.ROUTINEAUTH catalog view
Each row represents a user, group, or role that has been granted EXECUTE privilege on either a particular routine (function, method, or procedure) in the database that is not defined in a module or all routines in a particular schema in the database that are not defined in a module.
Column Name | Data Type | Nullable | Description |
---|---|---|---|
GRANTOR | VARCHAR (128) | Grantor of the privilege. SYSIBMif the privilege was granted by the system. |
|
GRANTORTYPE | CHAR (1) |
|
|
GRANTEE | VARCHAR (128) | Holder of the privilege. | |
GRANTEETYPE | CHAR (1) |
|
|
SCHEMA | VARCHAR (128) | Schema name of the routine. | |
SPECIFICNAME | VARCHAR (128) | Y | Specific name of the routine. If SPECIFICNAME is the null
value and ROUTINETYPE is not M, the privilege applies to all routines of the type specified in ROUTINETYPE in the schema specified in SCHEMA. If SPECIFICNAME is the null value and ROUTINETYPE is M, the privilege applies to all methods for the subject type specified by TYPENAME in the schema specified by TYPESCHEMA. If SPECIFICNAME is the null value, ROUTINETYPE is M, and both TYPENAME and TYPESCHEMA are null values, the privilege applies to all methods for all types in the schema. |
TYPESCHEMA | VARCHAR (128) | Y | Schema name of the type for the method. The null value if
ROUTINETYPE is not M. |
TYPENAME | VARCHAR (128) | Y | Unqualified name of the type for the method. The null value
if ROUTINETYPE is not M. If TYPENAME is the null value and ROUTINETYPE is M, the privilege applies to all methods for any subject type if they are in the schema specified by SCHEMA. |
ROUTINETYPE | CHAR (1) | Type of the routine.
|
|
EXECUTEAUTH | CHAR (1) | Privilege to execute the routine.
|
|
GRANT_TIME | TIMESTAMP | Time at which the privilege was granted. |