CONNX Data Integration Suite 14.8.0 | Reference Guide | CONNX Catalog Structure | View Description Tables | Table_Privileges View
 
Table_Privileges View
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