CONNX Data Integration Suite 14.8.0 | Reference Guide | CONNX Catalog Structure | View Description Tables | Column_Privileges View
 
Column_Privileges View
Describes the privileges on the columns 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
table catalog
TABLE_SCHEMA
identifier
n
schema name
TABLE_NAME
identifier
n
table name
COLUMN_NAME
identifier
n
column name
PRIVLEGE_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