Mimer SQL Reference Manual TOC PREV NEXT INDEX

Mimer Developer Site

www.mimer.com/developer


COLUMN_PRIVILEGES


The COLUMN_PRIVILEGES system view lists privileges on table columns that were granted by the current ident and privileges on table columns that were granted to the current ident or to PUBLIC.

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.
TABLE_CATALOG
VARCHAR(128)
The name of the catalog containing the table.
TABLE_SCHEMA
VARCHAR(128)
The name of the schema containing the table.
TABLE_NAME
VARCHAR(128)
The name of the table containing the column on which the column privilege has been granted.
COLUMN_NAME
VARCHAR(128)
The name of the column on which the privilege has been granted.
PRIVILEGE_TYPE
VARCHAR(20)
A value describing the type of the column privilege that was granted. One of:
"INSERT"
"REFERENCES"
"SELECT"
"UPDATE".
Note that when multiple table column privileges are granted to the same user at the same time (e.g. when the keyword "ALL" is used), multiple rows appear in this view (one for each privilege granted).
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.



Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
dbtechnology@upright.se
Mimer SQL Reference Manual TOC PREV NEXT INDEX