Describes the privileges for the tables defined in the catalog.
This view is part of the ANSI SQL-2 standard Information Schema.
|
Column |
Data Type |
N |
Description |
|
RECORD_NUMBER |
integer |
n |
unique identifier for this record of metadata |
|
GRANTOR |
identifier |
n |
User who granted privilege. |
|
GRANTEE |
identifier |
n |
User who was granted privilege. |
|
TABLE_CATALOG |
identifier |
n |
catalog name |
|
TABLE_SCHEMA |
identifier |
n |
schema name |
|
TABLE_NAME |
identifier |
n |
table name |
|
PRIVILEGE_TYPE |
enumeration |
n |
privilege type: SELECT or INSERT or DELETE or UPDATE or EXECUTE or REFERENCES |
|
IS_GRANTABLE |
yes_no |
n |
YES if privilege is grantable; NO if not |