Column name
|
Data type
|
Description
|
|
|
|
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. |
| OBJECT_CAT |
VARCHAR(128) |
The name of the catalog that contains the object character set or collation. |
| OBJECT_SCHEM |
VARCHAR(128) |
The name of the schema that contains the object character set or collation. |
| OBJECT_NAME |
VARCHAR(128) |
The name of the character set or collation. |
| OBJECT_TYPE |
VARCHAR(20) |
One of:
"CHARACTER SET" = the privilege is held on a character set
"COLLATION" = the privilege is held on a collation. |
| PRIVILEGE_TYPE |
VARCHAR(20) |
This will always be "USAGE". |
| 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. |
| REMARKS |
VARCHAR(254) |
May contain descriptive information about the privilege. |
