Column name
|
Data type
|
Description
|
| GRANTOR |
VARCHAR(128) |
The name of the ident who granted the privilege. |
| GRANTEE |
VARCHAR(128) |
The name of the ident to whom the privilege was granted. Granting a privilege to PUBLIC will result in only one row (per privilege granted) in this view and the name "PUBLIC" will be shown. |
| SPECIFIC_CATALOG |
VARCHAR(128) |
The catalog name for the specific name of the routine. |
| SPECIFIC_SCHEMA |
VARCHAR(128) |
The schema name for the specific name of the routine. |
| SPECIFIC_NAME |
VARCHAR(128) |
The specific name of the routine. |
| ROUTINE_CATALOG |
VARCHAR(128) |
The name of the catalog containing the routine. |
| ROUTINE_SCHEMA |
VARCHAR(128) |
The name of the schema containing the routine. |
| ROUTINE_NAME |
VARCHAR(128) |
The name of the routine. |
| PRIVILEGE_TYPE |
VARCHAR(128) |
The type of the privilege. |
| IS_GRANTABLE |
VARCHAR(3) |
One of:
"YES" = the privilege is held with the WITH GRANT OPTION
"NO" = the privilege is held without the WITH GRANT OPTION. |
